Re: WIP partial replication patch

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Hans-Juergen Schoenig <hs(at)cybertec(dot)at>
Subject: Re: WIP partial replication patch
Date: 2010-08-13 19:15:21
Message-ID: 5531.1281726921@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Boszormenyi Zoltan <zb(at)cybertec(dot)at> writes:
> attached is a WIP patch that will eventually implement
> partial replication, with the following syntax:

This fundamentally cannot work, as it relies on system catalogs to be
valid during recovery. Another rather basic problem is that you've
got to pass system catalog updates downstream (in case they affect
the tables being replicated) but if you want partial replication then
many of those updates will be incorrect for the slave machine.

More generally, though, we are going to have our hands full for the
foreseeable future trying to get the existing style of replication
bug-free and performant. I don't think we want to undertake any large
expansion of the replication feature set, at least not for some time
to come. So you can count on me to vote against committing anything
like this into core.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Boszormenyi Zoltan 2010-08-13 19:36:00 Re: WIP partial replication patch
Previous Message Tom Lane 2010-08-13 18:43:39 Re: review: xml_is_well_formed