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

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
replicasuper-simple.
 

That was a possible design, but that's not will be there for this
release.

I opposed adding the "we do the base backup for you" feature because
there are many ways of doing a base backup and it would likely have
restricted your options to do so. One issue that would cause is limiting
the speed of the base backup to a single libpq connection, which would
cause performance problems. So yes, super-simple, but not super-good for
many big users.

-- Simon Riggs           www.2ndQuadrant.com