Re: Doubt on pgbouncer

Поиск
Список
Период
Сортировка
От Rama Krishnan
Тема Re: Doubt on pgbouncer
Дата
Msg-id CAJWX+ENynPi70Ti9zK692e8=dgTLToXicS=3xtopdsvUJas40g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Doubt on pgbouncer  (Ben Chobot <bench@silentmedia.com>)
Список pgsql-general
Thank you for the clarification. 

On Sat, 3 Jul, 2021, 23:20 Ben Chobot, <bench@silentmedia.com> wrote:
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Damaged (during upgrade?) table, how to repair?
Следующее
От: Yi Sun
Дата:
Сообщение: Re: postgresql version 13 repo question