Re: Replication with partitions?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Dave Johansen <davejohansen(at)gmail(dot)com>
Cc: Feike Steenbergen <feikesteenbergen(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication with partitions?
Date: 2015-12-08 17:46:51
Message-ID: CAECtzeVhXpR7U7F3-X8gMBNRjk9g4==inUM+he3WA5_3rgFfSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le 8 déc. 2015 4:37 PM, "Dave Johansen" <davejohansen(at)gmail(dot)com> a écrit :
>
> On Tue, Dec 8, 2015 at 5:05 AM, Feike Steenbergen <
feikesteenbergen(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2015-12-08 17:47:35 Re: Replication with partitions?
Previous Message Yogi Barot 2015-12-08 16:32:50 Re: pg_upgrade error