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

2009-12-28 Thread Simon Riggs
On Fri, 2009-12-25 at 14:33 +0900, Fujii Masao wrote: > On Thu, Dec 24, 2009 at 6:03 PM, Simon Riggs wrote: > > I see it would work like this: Add a new option to recovery.conf, > > perhaps two_phase_backup = on. Startup creates a file called > > backup_in_progress then waits. When second phase of

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

2009-12-24 Thread Fujii Masao
On Thu, Dec 24, 2009 at 6:03 PM, Simon Riggs wrote: > I see it would work like this: Add a new option to recovery.conf, > perhaps two_phase_backup = on. Startup creates a file called > backup_in_progress then waits. When second phase of backup is complete > (7b), delete the file and then Startup p

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

2009-12-24 Thread Simon Riggs
On Thu, 2009-12-24 at 14:40 +0900, Fujii Masao wrote: > On Wed, Dec 23, 2009 at 3:54 AM, 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

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

2009-12-24 Thread Fujii Masao
On Wed, Dec 23, 2009 at 3:54 AM, 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 postgre