[csw-users] PostgreSQL 8.1.4 - Cant start

[ben short]

Hello again,

I am able to connect to the db from the machine via pgsql and have set
the postgres users password.

I am connecting to the machine via putty and have forwarded local port
5432 to localhost:5432, but I can seem to connect with pgAdmin. Do i
need to edit the pg_hdb.conf from its default setup?

Ben

On 11/24/06, ben short <ben at benshort.co.uk> wrote:
> 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
> >
>