Re: pg_ctl wish list

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_ctl wish list
Date: 2001-02-05 20:26:23
Message-ID: Pine.LNX.4.30.0102052053530.762-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane writes:

> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > To alleviate the need for a start up script somewhat we could perhaps fix
> > up pg_ctl to serve that purpose better.
>
> > -w should be the default, as has been suggested.
>
> Agreed.

But we need to make up a better way to wait for postmaster startup. The
current 'psql -l' is no good, as we have discussed, but if this thing is
going into system startup scripts mainstream now we can't have that kind
of random behaviour.

Actually, trying to connect is wrong-headed anyway. If the user has a
peculiar setup to disallow connections from the local host (virtual host
maybe), even if it is only a temporary misconfiguration, we should still
be able to start up in good faith.

How is "successfully started up" constrained anyway? Even if we had a way
to check that, the postmaster could still choose to abort briefly after
our check, e.g., during the backend reaping phase.

Maybe waiting on startup isn't so important to worry about it.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message 'Alfred Perlstein' 2001-02-05 20:52:05 Re: RE: Index grows huge, possible leakage?
Previous Message m w 2001-02-05 20:13:56 Can we modify 'text *' passed to a C function?