On 05/19/2014 01:37 PM, Erik Rijkers wrote:
pg_isready has --username:
-U, --username=USERNAME user name to connect as
so is replying when given a non-existent user not a bug?
pg_isready --username=xxxx -p 6544
/tmp:6544 - accepting connections
There is no user xxxx. (PG envvars are removed)
Per the manual page on pg_isready:
The options --dbname and --username can be used to avoid gratuitous
error messages in the logs, but are not necessary for proper
functionality.
The libpq entry on PQpingParams(), which pg_isready uses, has a bit more
details:
It is not necessary to supply correct user name, password, or
database name values to obtain the server status; however, if
incorrect values are provided, the server will log a failed
connection attempt.
BTW, I find the above PQpingParams() explanation much more clear than
one in pg_isready. I think we should use the same text in both places.
- Heikki
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
