Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing < solved - Mailing list pgsql-general

From Matthew D. Fuller
Subject Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup script not releasing < solved
Date
Msg-id 20020311035458.I57293@over-yonder.net
Whole thread Raw
In response to Re: Postgres not starting at boot(FreeBSD) - startup script not releasing < solved  ("Dave" <dave@hawk-systems.com>)
Responses Re: [ADMIN] Postgres not starting at boot(FreeBSD) - startup  ("Chad R. Larson" <clarson@eldocomp.com>)
List pgsql-general
On Sun, Mar 10, 2002 at 06:11:21PM -0500 I heard the voice of
Dave, and lo! it spake thus:
> 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

FWIW (after a quick glance at the default script and the manpage), "-w"
is the pg_ctl option that makes it wait.  I just take it out; it only
takes PG a few seconds to initialize, so it's ready to go long before
something would need to connect to it.

It could also be said that having -w implemented as invoking psql to try
to connect as the DB superuser assuming no password is a rather
inappropriate way of going about it, but that's another can of worms.



--
Matthew Fuller     (MF4839)     |    fullermd@over-yonder.net
Unix Systems Administrator      |    fullermd@futuresouth.com
Specializing in FreeBSD         |    http://www.over-yonder.net/

"The only reason I'm burning my candle at both ends, is because I
      haven't figured out how to light the middle yet"

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Time to case votes for PostgreSQL in the Java Developers Journal
Next
From: joerg.naumann@miele.de
Date:
Subject: error can't select an agregate function