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
