[ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing

2002-03-10 Thread Dave
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

Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing

2002-03-10 Thread Tom Lane
Dave [EMAIL PROTECTED] writes: DEBUG: Data Base System is starting up at Sat Mar 9 17:05:45 2002 DEBUG: Data Base System was shut down at Sat Mar 9 17:05:39 2002 DEBUG: Data Base System is in production state at Sat Mar 9 17:05:45 2002 Fast Shutdown request at Sat Mar 9 17:05:48 2002

Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing

2002-03-10 Thread Dave
Sorry, should point out that the stop is resulting from executing a ^c after running the script manually. Since the script runs... postgres starts, but from reading the startup script, it is waiting for the pid file to appear before reporting suscess... and it isn't doing this. Or at least

Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing

2002-03-10 Thread Dave
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

Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing

2002-03-10 Thread Matthew D. Fuller
On Sun, Mar 10, 2002 at 09:11:11AM -0500 I heard the voice of Dave, and lo! it spake thus: 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

Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing solved

2002-03-10 Thread Dave
Bingo! Dumb move. Dropped everything to password a few months back, never had the occasion to restart after that. Will work on tweaking the pg_hba.conf Thanks Matthew... if you are ever in Toronto, I owe you a beer. Dave At a guess, you've set it up to not automatically trust local users,