Re: replicating to a stopped server

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Joao Miguel Ferreira <joao(dot)mc(dot)ferreira(at)criticalsoftware(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: replicating to a stopped server
Date: 2007-10-17 09:23:46
Message-ID: 1192613026.4233.27.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2007-10-12 at 19:59 +0100, Richard Huxton wrote:

> You could use WAL archiving, but you'll want a fairly regular
> full-backup of PG's files otherwise the recovery could take a long time.
> See Ch 23 of the manuals for details.

Restartable recovery avoids the need to re-sync from the primary as
often as was the case with 8.1 and prior.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2007-10-17 10:12:19 Re: Calculation of per Capita on-the-fly - problems with SQL syntax
Previous Message Joris Dobbelsteen 2007-10-17 09:10:31 Re: newbie question