Re: pg_isready features

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: pg_isready features
Дата
Msg-id CAMsr+YHhhkSFnoYr=GPmioiZW3Hk8m54H=GWWW8TbnZDxCkxbA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_isready features  (Jimmy <jimmyjack@gmail.com>)
Список pgsql-hackers
On 16 June 2016 at 00:40, Jimmy <jimmyjack@gmail.com> wrote:

(1) I can (and do) use psql, pg_isready seems lighter and since it already supports credentials and DB name, I see very little harm for pg_isready to say back whether user logged IN or not using these credentials.


(2) timeout is not the same - timeout does not retry, its a simple timeout in case connection hangs, try it

That threw me recently, too.

If your DB is in recovery, pg_isready with a long timeout won't wait until it's accepting normal user connections or until timeout. There's no way to get that behaviour without a shell script loop or similar.

So yeah, +1 for this.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: 10.0
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: ERROR: ORDER/GROUP BY expression not found in targetlist