[csw-users] PostgreSQL 8.1.4 - Cant start

[James Lee]

On 23/11/06, 17:48:21, ben short <ben at benshort.co.uk> wrote regarding
[csw-users] PostgreSQL 8.1.4 - Cant start:

> I have install postgresql from blastwave but get the following error
> when I try to start it up.

> LOG: could not bind IPv6 socket: Cannot assign requested address
> HINT: Is another postmaster already running on port 5432? If not, wait
> a few seconds and retry.

I too see this in the log, doesn't say it's error.  Is it because we
don't have Ipv6 enabled?  If so it's nothing to worry about.



> When I look at prstat i see several postres processes running but no
> postmaster.

Check for postmaster with ps not prstat, in prstat the processes show as:

$ prstat -c -u postgres
   PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU PROCESS/NLWP

 16820 postgres   21M   15M sleep   41    0   0:00.00 0.3% postgres/1
 15771 postgres   21M   15M sleep   58    0   0:00.11 0.0% postgres/1
 13356 postgres   21M   15M sleep   58    0   0:00.00 0.0% postgres/1
   290 postgres   20M   14M sleep   48    0   0:00.20 0.0% postgres/1
 13587 postgres   21M   14M sleep   48    0   0:00.00 0.0% postgres/1
 16768 postgres   21M   14M sleep   58    0   0:00.00 0.0% postgres/1
 16662 postgres   21M   14M sleep   58    0   0:00.00 0.0% postgres/1
 13588 postgres   21M   14M sleep   58    0   0:00.00 0.0% postgres/1
   327 postgres 8568K 2016K sleep   58    0   0:00.00 0.0% postgres/1
   326 postgres 9424K 2784K sleep   58    0   0:00.01 0.0% postgres/1
   325 postgres   20M   12M sleep   59    0   0:00.17 0.0% postgres/1
Total: 11 processes, 11 lwps, load averages: 0.30, 0.14, 0.14


but as  postmaster with ps:


$ ps -u postgres -f
     UID   PID  PPID  C    STIME TTY      TIME CMD
postgres   325   290  0   Nov 17 ?        0:17
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres   326   290  0   Nov 17 ?        0:01
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres   290     1  0   Nov 17 ?        0:21
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres   327   326  0   Nov 17 ?        0:01
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres 13356   290  0 13:20:34 ?        0:01
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres 13588   290  0 14:41:46 ?        0:00
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres 15771   290  0 02:21:24 ?        0:11
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres 16662   290  0 08:24:15 ?        0:00
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres 16768   290  0 09:26:52 ?        0:00
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres 13587   290  0 14:41:46 ?        0:00
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata
postgres 16820   290  0 09:53:22 ?        0:00
/opt/csw/postgresql/bin/sparcv8/postmaster -D /var/opt/csw/pgdata


or with "pgrep -f postmaster".  As you have postgres processes running I
think it has started.





> All of my config files are straight out of the box.

> Anyone got any ideas?


Random hints, refer to:
/opt/csw/postgresql/share/doc/README-CSW.txt

In particular:
 + Check the shared memory settings.
 + Did you do "/etc/init.d/cswpostgres init" ?