Re: time-delayed standbys - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: time-delayed standbys
Date
Msg-id 4E0BD7A9.2050307@agliodbs.com
Whole thread Raw
In response to Re: time-delayed standbys  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 6/29/11 11:11 AM, Robert Haas wrote:
> If the standby gets far enough behind the master that the required
> files are no longer there, then it will switch to the archive, if
> available.

One more thing:

As I understand it (and my testing shows this), the standby *prefers*
the archive logs, and won't switch to streaming until it reaches the end
of the archive logs.  This is desirable behavior, as it minimizes the
load on the master.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: default privileges wording
Next
From: Robert Haas
Date:
Subject: Re: time-delayed standbys