RE: Bug? 'psql -l' in pg_ctl? - Mailing list pgsql-general

From Robert D. Nelson
Subject RE: Bug? 'psql -l' in pg_ctl?
Date
Msg-id 3A22B655@rba6.rbapro.com
Whole thread Raw
In response to Bug? 'psql -l' in pg_ctl?  (GH <grasshacker@over-yonder.net>)
List pgsql-general
>I fixed that today; if the database status is not open-for-business,
>the postmaster will tell you so right away instead of making you go
>through the authentication protocol first.  So a pg_ping could be
>written that just sends a connection request packet and sees what
>comes back.
>
>However, if we're running in TRUST or IDENT mode, it's possible that
>that technique will lead to launching a backend to no purpose.  So
>maybe we ought to extend the postmaster protocol to have a "query
>status" packet type.  Thoughts?

Would it be too much to just simply inclue an expect wrapper? You could even
have it put in enough wrong auth answers so that the backend closes if you
wanted.


Rob Nelson
rdnelson@co.centre.pa.us


pgsql-general by date:

Previous
From: "Alex Bolenok"
Date:
Subject: OVERLAPS
Next
From: "Nathan Barnett"
Date:
Subject: RE: Database cluster?