Tom Lane wrote:
> Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)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