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

From Dave Johansen
Subject Re: Replication with partitions?
Date
Msg-id CAAcYxUfX6brScO=ocoAyGPPd_gkCSW1nv61gQivXU-qsD5VZeQ@mail.gmail.com
Whole thread Raw
In response to Re: Replication with partitions?  (Feike Steenbergen <feikesteenbergen@gmail.com>)
Responses Re: Replication with partitions?
Re: Replication with partitions?
List 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 by date:

Previous
From: Feike Steenbergen
Date:
Subject: Re: Replication with partitions?
Next
From: Yogi Barot
Date:
Subject: Re: pg_upgrade error