Horton

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

David Steele <david@pgmasters.net>

View thread View on postgr.es
From: David Steele <david@pgmasters.net>
To: pgsql-hackers@postgresql.org
Date: 2017-07-24T19:59:32Z
Lists: pgsql-hackers 
On 7/24/17 3:28 PM, David Steele wrote:
> 
> Yes, and this is another behavioral change to consider -- one that is 
> more likely to impact users than the change to pg_stop_backup().  If 
> pg_basebackup is not currently waiting for WAL on a standby (but does on 
> a primary) then that's pretty serious.

My bad, before PG10 pg_basebackup did not check that WAL was archived on 
a primary *or* a standby unless the -x option was specified, as documented.

-- 
-David
david@pgmasters.net

Commits

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

  2. Implement backup API functions for non-exclusive backups