Fw: Postgresql 7 does not always start on RH 6.2

Thanks Tom

In the messages log I found
-PAM-pwdb[464]: (su) session opened for user postgres by (uid=0)
-PAS_pwdb[464]: (su) session closed for user postres

Also in /var/log there are files called postgresql but unzipped they all
have size zero.

The line in /etc/rc.d/init.d/postgresql that I think is starting postgresql
is
su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start
>/dev/null 2>&1"

from this I assume that it is not being started with -S (silent). Looking at
the man pages for postmaster it seems to imply that the logfile would be
/dev/null. I am afraid this is a little beyond my knowledge of linux.
Editing the file and changing /dev/null to say /var/log/something produces
an access denied.

How do I find this log file or alter the script to produce a log file?

Regards
Warren


-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Warren Flemmer <warren@netlab.co.za>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Saturday, October 14, 2000 6:35 PM
Subject: Re: [GENERAL] Postgresql 7 does not always start on RH 6.2


>"Warren Flemmer" <warren@netlab.co.za> writes:
>> But, I have one problem. On RedHat 6.2 I can not get postgresql 7 to
always
>> start. When booting I always get "Looks Good!" but I do not always get
the
>> PID (if not I get failed).
>
>Hm.  The postmaster should report some kind of complaint if it doesn't
>start.  Make sure that the postmaster isn't being started with a -S
>switch, and that its stdout and stderr are redirected into a logfile
>someplace.  Then look in the logfile after a startup failure, and let
>us know what you find.
>
> regards, tom lane