Re: [HACKERS] WIP partial replication patch

2010-08-14 Thread Tom Lane
Andres Freund 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. > I don't thi

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 writes: > >>> > >>> > attached is a WIP patch that will eventually implement

Re: [HACKERS] WIP partial replication patch

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

Re: [HACKERS] WIP partial replication patch

2010-08-13 Thread Tom Lane
Josh Berkus 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 this be ta

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 replicatin

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 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 catalo

Re: [HACKERS] WIP partial replication patch

2010-08-13 Thread Boszormenyi Zoltan
Tom Lane írta: > Boszormenyi Zoltan 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? What

Re: [HACKERS] WIP partial replication patch

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