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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: jakelist(at)zoho(dot)com
Subject: BUG #15168: "pg_isready -d" effectively ignores given database name
Date: 2018-04-24 04:15:14
Message-ID: 152454331410.19803.86605614092680300@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15168
Logged by: Jake
Email address: jakelist(at)zoho(dot)com
PostgreSQL version: 9.5.10
Operating system: Fedora 25
Description:

* Using Bash
* Tried to update as recommended. 9.6.12 does not appear to be available for
Fedora 25.

$ cd /run/media/jthomas/BackupOne/development/snowdrift

$ export PGDATA="$PWD"/.postgres-work
$ export PGHOST="$PGDATA"
$ export PGDATABASE="snowdrift"

$ pg_ctl initdb
$ pg_ctl start -w -o "-F -h '' -k "$PGHOST"" -l "$PGDATA"/log

# As you would expect; "pg_ctl initdb" created database "postgres":
$ pg_isready -d postgres
/run/media/jthomas/BackupOne/development/snowdrift/.postgres-work:5432 -
accepting connections

# Not expected, database "jibberish" does not exist:
$ pg_isready -d jibberish
/run/media/jthomas/BackupOne/development/snowdrift/.postgres-work:5432 -
accepting connections

# Just to confirm:
$ psql -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access
privileges
-----------+---------+----------+-------------+-------------+---------------------
postgres | jthomas | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | jthomas | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/jthomas
+
| | | | |
jthomas=CTc/jthomas
template1 | jthomas | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/jthomas
+
| | | | |
jthomas=CTc/jthomas
(3 rows)

# No database "jibberish"

Note: https://www.postgresql.org/docs/10/static/bug-reporting.html , 5.3
portrays the mailing list as the preferred method, but then the pgsql-bugs
page
asks that the bug reporting form be used instead.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2018-04-24 04:29:11 Re: BUG #15168: "pg_isready -d" effectively ignores given database name
Previous Message Dave Cramer 2018-04-23 22:25:50 Re: BUG #15158: JDBC driver has faulty comparison in method: haveMinimumServerVersion(String ver)