Re: Streaming Rep - 2-phase backups and reducing time to full replication - Mailing list pgsql-hackers

From decibel
Subject Re: Streaming Rep - 2-phase backups and reducing time to full replication
Date
Msg-id 6F7E417A-A9A6-4542-88B2-A47F81900E8E@decibel.org
Whole thread Raw
In response to Streaming Rep - 2-phase backups and reducing time to full replication  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Streaming Rep - 2-phase backups and reducing time to full replication  (Fujii Masao <masao.fujii@gmail.com>)
Re: Streaming Rep - 2-phase backups and reducing time to full replication  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
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 in the standby server. It will start streaming
> replication.
>
> 7. (b) Continue with second phase of base backup, copying all remaining
> files, ending with pg_stop_backup()

Dumb question: could the WAL streaming code be made to also ship base files? That would make setting up a streaming
replicasuper-simple. 
--
Jim C. Nasby, Database Architect                   jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: creating index names automatically?
Next
From: decibel
Date:
Subject: Re: Removing pg_migrator limitations