Re: Fw: Postgresql 7 does not always start on RH 6.2

Warren,

> su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
> start
> >/dev/null 2>&1"

Something like this:

su -l postgres -c "/usr/bin/og_ctl -D $PGDATA -p /usr/bin/postmaster start
>> /var/log/pgsql 2>&1"

Then check that /var/log/pgsql exists and is writeable by postgres user.
Eg, include pgsql in a group called log, then

# chown root.log /var/log
# chmod 0750 /var/log
# cd /var/log
# echo -n > ./pgsql
# chown postgres.root ./pgsql
# chmod 0600 ./pgsql

Also, make sure that /var and / are 5 for user postgres.
Another reason for postmaster to fail is a stale UNIX domain socket,
usually /tmp/.s.PGSQL.5432 It remains in /tmp if for some reason postmaster
hasn't been stopped correctly.

HTH

Ed

---
Well I tried to be meek
And I have tried to be mild
But I spat like a woman
And I sulked like a child
I have lived behind the walls
That have made me alone
Striven for peace
Which I never have known

Dire Straits, Brothers In Arms, The Man's Too Strong (Knopfler)