Horton

Re: pg_stop_backup(wait_for_archive := true) on standby server

Paul A Jungwirth <pj@illuminatedcomputing.com>

View thread View on postgr.es
From: Paul A Jungwirth <pj@illuminatedcomputing.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Michael Paquier <michael.paquier@gmail.com>, Stephen Frost <sfrost@snowman.net>, Magnus Hagander <magnus@hagander.net>, Masahiko Sawada <sawada.mshk@gmail.com>, Noah Misch <noah@leadboat.com>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-08-06T06:03:26Z
Lists: pgsql-hackers 
On Sat, Aug 5, 2017 at 6:22 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Sat, Aug 5, 2017 at 4:28 PM, Paul A Jungwirth
> <pj@illuminatedcomputing.com> wrote:
>> I don't have an opinion on the urgency of back-porting a fix, but if
>> pg_stop_backup(boolean) allows for inconsistent backups, it does sound
>> like a problem on 9.6 too.
>
> It doesn't.  The talk about inconsistent backups is, I think, not a
> very precise way of speaking.

Thank you for the reassurance and the detailed explanation!

Paul

Commits

  1. Make pg_stop_backup's wait_for_archive flag work on standbys.

  2. Implement backup API functions for non-exclusive backups