Re: Replication with partitions? - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Replication with partitions?
Date
Msg-id CAECtzeVhXpR7U7F3-X8gMBNRjk9g4==inUM+he3WA5_3rgFfSQ@mail.gmail.com
Whole thread Raw
In response to Re: Replication with partitions?  (Dave Johansen <davejohansen@gmail.com>)
List 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 by date:

Previous
From: Yogi Barot
Date:
Subject: Re: pg_upgrade error
Next
From: Scott Ribe
Date:
Subject: Re: Replication with partitions?