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