Re: Postgres 9.0 Streaming Replication and Load Balancing?

Поиск
Список
Период
Сортировка
От Sumit Raja
Тема Re: Postgres 9.0 Streaming Replication and Load Balancing?
Дата
Msg-id CAB4mO2czCn50Xy19XDkO+Wa=Nm+TknhqjAUE5G1dFfnM3Fv9Bg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres 9.0 Streaming Replication and Load Balancing?  (Paulo Correia <paulo.correia@pdmfc.com>)
Ответы Re: Postgres 9.0 Streaming Replication and Load Balancing?  (Paulo Correia <paulo.correia@pdmfc.com>)
Список pgsql-general
On 14 May 2012 17:28, Paulo Correia <paulo.correia@pdmfc.com> wrote:
> Hello all!

> Having a Postgres 9.0 with assynchronous streaming replication to a
> hot-standby slave, both with CentOs 5.6, how can I use both DB instances for
> query load balancing?
> I've tried with pgPool-II but the pooling mechanism is disruptive with the
> existing pool on the application servers.

Is the application RW or read only? What is the disruption being
caused? Are you seeing specific exceptions?

- Sumit

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

Предыдущее
От: Chris Angelico
Дата:
Сообщение: Re: Uppercase to lowercase trigger?
Следующее
От: Condor
Дата:
Сообщение: Vacuum does not show in pg_stat_all_tables