Re: FDW, connections, master v replica

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.
https://github.com/CrunchyData/crunchy-proxy

On Tue, May 18, 2021, 7:28 PM Godfrin, Philippe E <philippe(dot)godfrin(at)nov(dot)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
>
> E Philippe(dot)Godfrin(at)nov(dot)com
>
>
>