Re: Libpq support to connect to standby server as priority - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: Libpq support to connect to standby server as priority
Date
Msg-id CADK3HH+4v05DfO3hr0UMCMoN8PFph=GWkKixjxL_RgJ1OPS0=Q@mail.gmail.com
Whole thread Raw
In response to Re: Libpq support to connect to standby server as priority  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-hackers






Now I will add the another parameter target_server_type to choose the primary, standby or prefer-standby
as discussed in the upthreads with a new GUC variable.


So just to further confuse things here is a use case for "preferPrimary"

This is from the pgjdbc list.

"if the master instance fails, we would like the driver to communicate with the secondary instance for read-only operations before the failover process is commenced. The second use-case is when the master instance is deliberately shut down for maintenance reasons and we do not want to fail over to the secondary instance, but instead allow it to process user queries throughout the maintenance."


see this for the thread.


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: XML/XPath issues: text/CDATA in XMLTABLE, XPath evaluated withwrong context
Next
From: David Rowley
Date:
Subject: Re: pgbench MAX_ARGS