Horton

Re: BUG #19002: `pg_isready` unexpectedly succeeds on incorrect `--dbname` and/or `--username`

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Samuel Marks <samuelmarks@gmail.com>
Cc: Jacob Champion <jacob.champion@enterprisedb.com>, pgsql-bugs@lists.postgresql.org
Date: 2025-07-30T03:27:35Z
Lists: pgsql-bugs 
Samuel Marks <samuelmarks@gmail.com> writes:
> Hmm I suppose that works, but really I was using it as a "can i connect"
> check.

That's explicitly not its job.  Why don't you just try to connect?
Or if you want a command-line tool, consider

	psql ...connection options... -c 'select 1'

			regards, tom lane