Re: Proposal: Implement failover on libpq connect level.

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Proposal: Implement failover on libpq connect level.
Дата
Msg-id CA+TgmoadWzS=WbP_aJL5B=pnmbZsnjSwrX8njK=fJJoGfQYXQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposal: Implement failover on libpq connect level.  (Jaime Casanova <jaime.casanova@2ndquadrant.com>)
Список pgsql-hackers
On Tue, Aug 18, 2015 at 12:53 PM, Jaime Casanova
<jaime.casanova@2ndquadrant.com> wrote:
> This is not completely true, you can always use something like
> pgbouncer or other middleware to change the server to which clients
> connect. you still need to solve the fact that you will have a
> read-only server at the other side.
>
> something like repmgr + pgbouncer will work fine.

Sure, but pgbouncer is an extra hop, and has its own foibles.  There's
real appeal to doing this in the client.

> i agree that once/if we ever have multimaster included then this could
> be a good idea

I think it has a lot of appeal *now*.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: Proposal: Implement failover on libpq connect level.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [patch] psql tab completion for grant execute