Rama Krishnan wrote on 7/3/21 8:35 AM:
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. |
