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

Поиск
Список
Период
Сортировка
Искать
От
Jacob Champion
Тема
Re: BUG #19002: `pg_isready` unexpectedly succeeds on incorrect `--dbname` and/or `--username`
Дата
Msg-id
CAOYmi+mAWLmb6egMet8LFy_vDC7euHLFHQnFjL36MiFrjvySTg@mail.gmail.com
Ответ на
BUG #19002: `pg_isready` unexpectedly succeeds on incorrect `--dbname` and/or `--username` (PG Bug reporting form)
Список
Дерево обсуждения
BUG #19002: `pg_isready` unexpectedly succeeds on incorrect `--dbname` and/or `--username` PG Bug reporting form <noreply@postgresql.org>
Re: BUG #19002: `pg_isready` unexpectedly succeeds on incorrect `--dbname` and/or `--username` Jacob Champion <jacob.champion@enterprisedb.com>
Re: BUG #19002: `pg_isready` unexpectedly succeeds on incorrect `--dbname` and/or `--username` Samuel Marks <samuelmarks@gmail.com>
Re: BUG #19002: `pg_isready` unexpectedly succeeds on incorrect `--dbname` and/or `--username` Tom Lane <tgl@sss.pgh.pa.us> 
On Tue, Jul 29, 2025 at 12:45 PM PG Bug reporting form
 wrote:
> /  > pg_isready -U fff
> /tmp:5432 - accepting connections
> /  > pg_isready -U fff -d555
> /tmp:5432 - accepting connections
> ```
>
> (`fff` is not a user and `555` is not a db on my installation)

Hi Samuel, this behavior is explained in the docs [1]:

> 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.

So it's essentially just a courtesy to whoever's watching your logs.

--Jacob

[1] https://www.postgresql.org/docs/current/app-pg-isready.html#APP-PG-ISREADY-NOTES
В списке pgsql-bugs по дате отправления
Предыдущее
От: PG Bug reporting form
Дата:
Следующее
От: Jeff Davis
Дата:
FAQ