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 по дате отправления: