On Tue, 2021-05-18 at 13:57 +0000, Godfrin, Philippe E wrote:
> Does anyone know of a method to define a foreign server to point to a patroni
> cluster of 2 postgres cluster instances and be able to select between the master for RW and the replica for RO?
Use the "target_session_attrs" connection parameter.
It can be used to always connect to the primary, and from v14 on
it can also be used to preferably connect to the standby.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com