Re: Wierd quirk of HS/SR, probably not fixable - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Wierd quirk of HS/SR, probably not fixable
Date
Msg-id 4BD6FD0B.9030301@enterprisedb.com
Whole thread Raw
In response to Re: Wierd quirk of HS/SR, probably not fixable  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Wierd quirk of HS/SR, probably not fixable  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> Hmm, we could throw an error in the standby, when we see a shutdown
>> checkpoint while we're waiting for an end-backup record. If the database
>> was shut down before pg_stop_backup(), we know that the backup was
>> cancelled and the end-backup record we're waiting for will never arrive.
> 
> Isn't the above statement complete nonsense?  There's nothing to stop
> the DBA from issuing pg_stop_backup() after he restarts the master.

pg_stop_backup() can't be called if there's no backup in progress.
Restart cancels it.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: recovery_connections cannot start
Next
From: Merlin Moncure
Date:
Subject: Re: Differential backup