Rama Krishnan wrote on 7/3/21 8:35 AM:
>
> Hi Team,
>
> How can I split read and write queries using pgbouncer
You do it with your application. Make a pgbouncer database for
read/write queries and point it at your postgresql primary, and then
make a second pgbouncer database for read-only queries and point it at a
replica. Have your application connect to the proper database, depending
upon its needs.
It's not transparent, but it is effective.