Re: pg_stop_backup does not complete

Josh Berkus wrote:
> OK, can you go through the reasons why pg_stop_backup would not
> complete?  

pg_stop_backup() doesn't complete until all the WAL segments needed to
restore from the backup are archived. If archive_command is failing,
that never happens.

> And why it's a problem to have it complete? 

Because then you would conclude that the backup is finished and you have
all the data you need to restore safely in the archive. If
archive_command is failing, that's not happening.

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