pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication with partitions?
6+ messages / 5 participants
[nested] [flat]
* Replication with partitions?
@ 2015-12-07 18:22 Dave Johansen <davejohansen@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Dave Johansen @ 2015-12-07 18:22 UTC (permalink / raw)
To: pgsql-admin
We're moving to Postgres 9.2 on RHEL 7 and as part of this we are going to
setup a slave database as our data warehouse. We would like to use the
streaming replication that's built into 9.2, so we would want to remove all
of the data from an old partition on the master but have it stay on the
slave. I was reading the documentation [1] and it sound like this is not
possible.
Is there a way to make this sort of setup work with the streaming
replication that's built into Postgres 9.2?
Thanks,
Dave
[1]:
http://www.postgresql.org/docs/9.2/static/different-replication-solutions.html
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Replication with partitions?
@ 2015-12-08 12:05 Feike Steenbergen <feikesteenbergen@gmail.com>
parent: Dave Johansen <davejohansen@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Feike Steenbergen @ 2015-12-08 12:05 UTC (permalink / raw)
To: Dave Johansen <davejohansen@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Replication with partitions?
@ 2015-12-08 15:35 Dave Johansen <davejohansen@gmail.com>
parent: Feike Steenbergen <feikesteenbergen@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Dave Johansen @ 2015-12-08 15:35 UTC (permalink / raw)
To: Feike Steenbergen <feikesteenbergen@gmail.com>; +Cc: 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,
Dave
[1] http://slony.info/
[2] https://bucardo.org/wiki/Bucardo
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Replication with partitions?
@ 2015-12-08 17:46 Guillaume Lelarge <guillaume@lelarge.info>
parent: Dave Johansen <davejohansen@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Guillaume Lelarge @ 2015-12-08 17:46 UTC (permalink / raw)
To: Dave Johansen <davejohansen@gmail.com>; +Cc: Feike Steenbergen <feikesteenbergen@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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Replication with partitions?
@ 2015-12-08 17:47 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Dave Johansen <davejohansen@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Scott Ribe @ 2015-12-08 17:47 UTC (permalink / raw)
To: Dave Johansen <davejohansen@gmail.com>; +Cc: pgsql-admin
On Dec 8, 2015, at 8:35 AM, Dave Johansen <davejohansen@gmail.com> wrote:
>
> Does 9.3 or 9.4 support this sort of configuration?
No.
> 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?
I know Slony does, but I don't have any recommendation for one or the other.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Replication with partitions?
@ 2015-12-09 00:59 FattahRozzaq <ssoorruu@gmail.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 6+ messages in thread
From: FattahRozzaq @ 2015-12-09 00:59 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Dave Johansen <davejohansen@gmail.com>; pgsql-admin
Hi Dave,
I don't know if DRBD will help to fulfil your requirement.
But DRBD is a nice one to try since it will replicate a whole
disk/volume from 1 server to backup server.
Therefore, you'll need a dedicated disk/volume for your PostgreSQL
data directory to be replicated to the same size of disk/volume in the
backup server.
On 09/12/2015, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
> On Dec 8, 2015, at 8:35 AM, Dave Johansen <davejohansen@gmail.com> wrote:
>>
>> Does 9.3 or 9.4 support this sort of configuration?
>
> No.
>
>> 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?
>
> I know Slony does, but I don't have any recommendation for one or the
> other.
>
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> http://www.elevated-dev.com/
> https://www.linkedin.com/in/scottribe/
> (303) 722-0567 voice
>
>
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2015-12-09 00:59 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-12-07 18:22 Replication with partitions? Dave Johansen <davejohansen@gmail.com>
2015-12-08 12:05 ` Feike Steenbergen <feikesteenbergen@gmail.com>
2015-12-08 15:35 ` Dave Johansen <davejohansen@gmail.com>
2015-12-08 17:46 ` Guillaume Lelarge <guillaume@lelarge.info>
2015-12-08 17:47 ` Scott Ribe <scott_ribe@elevated-dev.com>
2015-12-09 00:59 ` FattahRozzaq <ssoorruu@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox