Re: Determine if a user and database are available

On Fri, Sep 2, 2022 at 5:43 PM Christophe Pettus <xof@thebuild.com> wrote:
>
> > On Sep 2, 2022, at 14:22, Jeffrey Walton <noloader@gmail.com> wrote:
> > Given the NOTES in the man page, how do we determine if a user and
> > database are present using the shell? Is there another utility we
> > should be using?
>
> pg_isready literally only checks that the server can be reached over the connection path (network or sockets), not
thatany login credentials work.  You can use psql do that, though:
 
>
>         psql <connection info) -c "SELECT 1"
>
> ... will return an error if the connection information can't be used to successfully log in.

Now available as a direct replacement for pg_isready :
https://github.com/noloader/pg_check_conn .

Jeff