Re: [HACKERS] WIP partial replication patch

2010-08-14 Thread Boszormenyi Zoltan
Andres Freund írta: On Fri, Aug 13, 2010 at 09:36:00PM +0200, Boszormenyi Zoltan wrote: Tom Lane írta: Boszormenyi Zoltan z...@cybertec.at writes: attached is a WIP patch that will eventually implement partial replication, with the following syntax: This

Re: [HACKERS] WIP partial replication patch

2010-08-14 Thread Andres Freund
On Sat, Aug 14, 2010 at 08:40:24AM +0200, Boszormenyi Zoltan wrote: Andres Freund írta: On Fri, Aug 13, 2010 at 09:36:00PM +0200, Boszormenyi Zoltan wrote: Tom Lane írta: Boszormenyi Zoltan z...@cybertec.at writes: attached is a WIP patch that will eventually implement partial

Re: [HACKERS] WIP partial replication patch

2010-08-14 Thread Tom Lane
Andres Freund and...@anarazel.de writes: On Sat, Aug 14, 2010 at 08:40:24AM +0200, Boszormenyi Zoltan wrote: And in this patch, the startup process only tries to connect after signalling the postmaster that a consistent state is reached. And the connection has a reasonable timeout built in.

Re: [HACKERS] WIP partial replication patch

2010-08-13 Thread Tom Lane
Boszormenyi Zoltan z...@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

Re: [HACKERS] WIP partial replication patch

2010-08-13 Thread Boszormenyi Zoltan
Tom Lane írta: Boszormenyi Zoltan z...@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. Just like Hot Standby, no?

Re: [HACKERS] WIP partial replication patch

2010-08-13 Thread Andres Freund
On Fri, Aug 13, 2010 at 09:36:00PM +0200, Boszormenyi Zoltan wrote: Tom Lane írta: Boszormenyi Zoltan z...@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

Re: [HACKERS] WIP partial replication patch

2010-08-13 Thread Josh Berkus
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. Couldn't this be taken care of by replicating

Re: [HACKERS] WIP partial replication patch

2010-08-13 Thread Tom Lane
Josh Berkus j...@agliodbs.com writes: 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. Couldn't