Re: Auotreconnect/failover libpq

Поиск
Список
Период
Сортировка
От Oleksandr Shulgin
Тема Re: Auotreconnect/failover libpq
Дата
Msg-id CACACo5S=2w0Xf7Qw3jYJcBKoP1BYVn9D31F6B_xor_wF6UqFYA@mail.gmail.com
обсуждение исходный текст
Ответ на Auotreconnect/failover libpq  (Marcin Giedz <marcin.giedz@arise.pl>)
Список pgsql-general
On Fri, Oct 28, 2016 at 10:08 AM, Marcin Giedz <marcin.giedz@arise.pl> wrote:
>
> Hello,
>
> This time question about client's autoreconnect (failover to the same node) after disconnection. Let's assume I've got 1 node SQL server and clients connected to this machine. Is there any native autoreconnect method in libpq (client's software uses libpq C++) - something like SELECT 1 or other options available for clients to (re)establish connection to the server again after they loose it ? or I need to implement this myself ?

Hi,

PQreset might be the interface you are looking for: https://www.postgresql.org/docs/current/static/libpq-connect.html#LIBPQ-PQRESET

This is how psql handles re-connection when its current connection gets closed in an interactive session.

--
Alex

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

Предыдущее
От: Marcin Giedz
Дата:
Сообщение: Auotreconnect/failover libpq
Следующее
От: Michael Banck
Дата:
Сообщение: Fast Primary shutdown only after wal_sender_timeout