On Fri, Sep 2, 2022 at 5:43 PM Christophe Pettus <x...@thebuild.com> wrote: > > > On Sep 2, 2022, at 14:22, Jeffrey Walton <noloa...@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 that any 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
