Re: recovery_target_time and standby_mode - Mailing list pgsql-hackers

From Robert Haas
Subject Re: recovery_target_time and standby_mode
Date
Msg-id CA+Tgmob9g98pgO==4eg6Q6RDCXhgr+ck2rHH8ST-DwW7+Avijg@mail.gmail.com
Whole thread Raw
In response to Re: recovery_target_time and standby_mode  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Fri, Nov 7, 2014 at 1:40 PM, Josh Berkus <josh@agliodbs.com> wrote:
> Is the current interaction of recovery_target_time and standby_mode
> (that is, that recovery_target_time causes standby_mode to be ignorned)
> the correct behavior?

I think this summary of the behavior is probably not correct in
detail.  For example, if the recovery target isn't reached by the time
the standby reaches the end of archived WAL, I think standby_mode will
affect what happens next.

I do think that the documentation of standby_mode ought to mention
that recovery_target_whatever can cause the server to promote even
when standby_mode is on.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: recovery_target_time and standby_mode
Next
From: Andrew Dunstan
Date:
Subject: Re: row_to_json bug with index only scans: empty keys!