Re: [HACKERS] Streaming Rep - 2-phase backups and reducing time to full replication

2009-12-24 Thread Andreas 'ads' Scherbaum
On Thu, 24 Dec 2009 09:58:20 + Simon Riggs wrote: > On Tue, 2009-12-22 at 15:33 -0600, decibel wrote: > > > Dumb question: could the WAL streaming code be made to also ship base > > files? That would make setting up a streaming replica super-simple. > > That was a possible design, but that'

Re: [HACKERS] Streaming Rep - 2-phase backups and reducing time to full replication

2009-12-24 Thread Simon Riggs
On Tue, 2009-12-22 at 15:33 -0600, decibel wrote: > Dumb question: could the WAL streaming code be made to also ship base files? > That would make setting up a streaming replica super-simple. That was a possible design, but that's not will be there for this release. I opposed adding the "we do

Re: [HACKERS] Streaming Rep - 2-phase backups and reducing time to full replication

2009-12-24 Thread Fujii Masao
On Wed, Dec 23, 2009 at 6:33 AM, decibel wrote: > Dumb question: could the WAL streaming code be made to also ship base files? No. > That would make setting up a streaming replica super-simple. Agreed, but it's not easy to implement that. So I'm thinking that it's out of the scope of the develo

Re: [HACKERS] Streaming Rep - 2-phase backups and reducing time to full replication

2009-12-23 Thread decibel
On Dec 22, 2009, at 12:54 PM, Simon Riggs wrote: > 9. Create a recovery command file in the standby server with parameters > required for streaming replication. > > 7. (a) Make a base backup of minimal essential files from primary > server, load this data onto the standby. > > 10. Start postgres

[HACKERS] Streaming Rep - 2-phase backups and reducing time to full replication

2009-12-22 Thread Simon Riggs
Some ideas to improve current behaviour of SR http://wiki.postgresql.org/wiki/Streaming_Replication The current startup process is copied below. (7) gives some issues if it is a very long step, notably that the master may fill with data and then break off the connection before replication is full