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