Postgresql 7 does not always start on RH 6.2

Started by Warren Flemmerover 25 years ago2 messagesgeneral
Jump to latest
#1Warren Flemmer
warren@netlab.co.za

Greetings

To start, thanks to all concerned for PostgreSQL. I have been impressed.

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). I can reboot ten times and probably 5 of the 10
times postgresql does not start and the other times it starts fine. I can
find not reason for it not starting. I have tried changing the value in the
run level between 15 to 95 with the same results. In the postgresql script
in /etc/rc.d/init.d/postgresql I found a sleep statement that I have tried
increasing to 20 seconds with the same results. When postgresql does not
start it will start manually without any problem or if I change the
run-level to 5 or 3 it starts. I have been looking at this problem for a few
days now and I seem to closer to a solution.

Any ideas would be appreciated.

Regards
Warren

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Warren Flemmer (#1)
Re: 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