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)