Auotreconnect/failover libpq
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 ?
Thx
Marcin
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