Standby servers and incrementally updated backups - Mailing list pgsql-general

From Erik Jones
Subject Standby servers and incrementally updated backups
Date
Msg-id 6702ED13-DD96-4160-A750-88F8CBFD2264@myemma.com
Whole thread Raw
Responses Re: Standby servers and incrementally updated backups  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-general
It is my understanding that once a standby server has reached the
point where it is often waiting for wal files to replay, it is pretty
much caught up to the primary server, with the differences being in
whatever wal files are currently in queue to be archived by the
primary.  If I'm correct, then for large databases wherein it can
take hours to take a base backup, is there anything to be gained by
using incrementally updated backups?

Erik Jones

Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Automatic install on windows
Next
From: Erik Jones
Date:
Subject: Re: yet another simple SQL question