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