Thread: FDW, connections, master v replica
Greetings,
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?
Thanks,
pg
Phil Godfrin | Database Administrator
NOV
NOV US | Engineering Data
9720 Beechnut St | Houston, Texas 77036
M 281.825.2311
I guess we do not have any mechanism or proxy that parses query to redirect it to master or replica.
I was playing with crunchy proxy and read that if the application can provide *read hints*, it would redirect those queries to read replicas, else all go to primary.
On Tue, May 18, 2021, 7:28 PM Godfrin, Philippe E <philippe.godfrin@nov.com> wrote:
Greetings,
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?
Thanks,
pg
Phil Godfrin | Database Administrator
NOV
NOV US | Engineering Data
9720 Beechnut St | Houston, Texas 77036
M 281.825.2311