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

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: decibel <decibel(at)decibel(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Subject: Re: Streaming Rep - 2-phase backups and reducing time to full replication
Date: 2009-12-24 09:58:20
Message-ID: 1261648700.7442.16152.camel@ebony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 replica super-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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2009-12-24 14:21:11 Re: About the CREATE TABLE LIKE indexes vs constraints issue
Previous Message Simon Riggs 2009-12-24 09:03:02 Re: Streaming Rep - 2-phase backups and reducing time to full replication