Search Postgresql Archives

Re: Doubt on pgbouncer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux