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.