Re: Replication with partitions?

From: Feike Steenbergen <feikesteenbergen(at)gmail(dot)com>
To: Dave Johansen <davejohansen(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Replication with partitions?
Date: 2015-12-08 12:05:11
Message-ID: CAK_s-G3c9pip7v=GtcDPet2R_nRMtsciO1_cpY3H+O8y+PX1hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

regards,

Feike

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Johansen 2015-12-08 15:35:41 Re: Replication with partitions?
Previous Message Bruce Momjian 2015-12-07 21:04:55 Re: pg_upgrade error