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

From Simon Riggs
Subject Re: Streaming Rep - 2-phase backups and reducing time to full replication
Date
Msg-id 1261648700.7442.16152.camel@ebony
Whole thread Raw
In response to Re: Streaming Rep - 2-phase backups and reducing time to full replication  (decibel <decibel@decibel.org>)
Responses Re: Streaming Rep - 2-phase backups and reducing time to full replication  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Streaming Rep - 2-phase backups and reducing time to full replication
Next
From: Dimitri Fontaine
Date:
Subject: Re: About the CREATE TABLE LIKE indexes vs constraints issue