Re: WIP partial replication patch - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WIP partial replication patch
Date
Msg-id 5531.1281726921@sss.pgh.pa.us
Whole thread Raw
In response to WIP partial replication patch  (Boszormenyi Zoltan <zb@cybertec.at>)
Responses Re: WIP partial replication patch  (Boszormenyi Zoltan <zb@cybertec.at>)
Re: WIP partial replication patch  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Boszormenyi Zoltan <zb@cybertec.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: review: xml_is_well_formed
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: WIP partial replication patch