Re: Replication with partitions?

Поиск
Список
Период
Сортировка
От Dave Johansen
Тема Re: Replication with partitions?
Дата
Msg-id CAAcYxUfX6brScO=ocoAyGPPd_gkCSW1nv61gQivXU-qsD5VZeQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication with partitions?  (Feike Steenbergen <feikesteenbergen@gmail.com>)
Ответы Re: Replication with partitions?
Re: Replication with partitions?
Список pgsql-admin
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?
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?

Thanks,

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

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