Re: Replication with partitions?

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Replication with partitions?
Дата
Msg-id CAECtzeVhXpR7U7F3-X8gMBNRjk9g4==inUM+he3WA5_3rgFfSQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication with partitions?  (Dave Johansen <davejohansen@gmail.com>)
Список pgsql-admin

Le 8 déc. 2015 4:37 PM, "Dave Johansen" <davejohansen@gmail.com> a écrit :
>
> On Tue, Dec 8, 2015 at 5:05 AM, Feike Steenbergen <feikesteenbergen@gmail.com> wrote:
>>
>> Dave,
>>
>> The built-in streaming replication of 9.2 gives you everything, you cannot cherrypick which tables will be replicated and which one will not be replicated.
>> Basically: The streaming replica will be an exact copy of you primary cluster.
>>
>> So the answer to your question is no, it's not possible with the streaming replication in 9.2.
>
>
> Does 9.3 or 9.4 support this sort of configuration?

Nope.

> If not, from the table in the documentation, it looks like Slony [1] and Bucardo [2] would both work, so does any one have any recommendations?
>

Slony would be my choice because I know it pretty well. The same cannot be said of bucardo.

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

Предыдущее
От: Yogi Barot
Дата:
Сообщение: Re: pg_upgrade error
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: Replication with partitions?