[csw-users] PostgreSQL 8.1.4 - Cant start

[ben short]

James,

Ah yes I can see the postmaster deamons when I do ps -u postgres -f.

Many thanks.

Ben


On 11/24/06, James Lee <james at blastwave.org> wrote:
> 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" ?
> _______________________________________________
> users mailing list
> users at lists.blastwave.org
> https://lists.blastwave.org/mailman/listinfo/users
>