Re: Postgres not starting at boot(FreeBSD) - startup script

hold the farm...

>>> Try this on for size...   recently during a reboot (first in about 3
>>months for
>>> this particular server) our entire rc.d directory failed to start...
>> after some
>>> hacking of the rc file to output some helpful debuggin, it was
>>apparent that the
>>> 010.pgsql.sh script in /usr/local/etc/rc.d was timing out and causing any
>>> directives thereafter not to be processed.
>>
>>have you tried manually doing "pg_ctl restart" to see if any problems
>>pop-up? Maybe it is not a script error, but some other issue with the db
>>server.

did the following,  stopped the server totally...  then ran the following.

web5# su -l pgsql -c 'exec /usr/local/pgsql/bin/pg_ctl start'
postmaster successfully started up.
web5# DEBUG:  Data Base System is starting up at Sun Mar 10 14:32:46 2002
DEBUG:  Data Base System was shut down at Sun Mar 10 14:32:04 2002
DEBUG:  Data Base System is in production state at Sun Mar 10 14:32:46 2002

web5#
web5# su -l pgsql -c 'exec /usr/local/pgsql/bin/pg_ctl restart'
Smart Shutdown request at Sun Mar 10 14:33:25 2002
Waiting for postmaster shutting down..................................The Data
Base System is shutting down
..........The Data Base System is shutting down
...The Data Base System is shutting down
....The Data Base System is shutting down
...The Data Base System is shutting down
.........pg_ctl: postmaster does not shut down
web5# The Data Base System is shutting down
The Data Base System is shutting down
The Data Base System is shutting down
The Data Base System is shutting down

    Hmmm...  check that its still running...

web5# ps -aux | grep pgsql
pgsql  81016  0.0  0.1   628  452  p0  I     2:32PM   0:00.00 /bin/sh /usr/loca
pgsql  81018  0.0  0.3  4080 2404  p0  I     2:32PM   0:00.03 /usr/local/pgsql/
pgsql  81082  0.0  0.4  4508 3008  p0  I     2:33PM   0:00.03 /usr/local/pgsql/
pgsql  81083  0.0  0.4  4556 3364  p0  I     2:33PM   0:00.06 /usr/local/pgsql/
web5#

    ok, lets try and use the rc.d script...

web5# /usr/local/etc/rc.d/010* stop
Fast Shutdown request at Sun Mar 10 14:37:28 2002
Aborting any active transaction...
Waiting for postmaster shutting down..FATAL 1:  The system is shutting down
FATAL 1:  The system is shutting down
NOTICE:  AbortTransaction and not in in-progress state
.NOTICE:  AbortTransaction and not in in-progress state
DEBUG:  Data Base System shutting down at Sun Mar 10 14:37:28 2002
DEBUG:  Data Base System shut down at Sun Mar 10 14:37:28 2002
done.
postmaster successfully shut down.
web5#

    Thats interesting,  perhaps pg_ctl is hosed?

web5# ps -aux | grep pgsql
web5#


Ideas?

Dave