Re: BUG #15168: "pg_isready -d" effectively ignores given database name

Ah-ha. Thank you for pointing that out. I did not notice.

In case you're interested, I used a StackOverflow solution to programmatically determine whether a database exists, after first ensuring that the cluster has been initialized and that the server is running.

Thank you for your rapid response,

Jake
---- On Mon, 23 Apr 2018 21:29:11 -0700 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote ----

On Monday, April 23, 2018, PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:

# Not expected, database "jibberish" does not exist:

$ pg_isready -d jibberish

/run/media/jthomas/BackupOne/development/snowdrift/.postgres-work:5432 -

accepting connections

The notes section of the docs for the command cover this behavior. It is not a bug, the utility answers whether the server will accept connections generally, not that a specific connection string and credentials are valid.

David J.