Re: pg_stop_backup does not complete - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: pg_stop_backup does not complete
Date
Msg-id 4B85897A.2040408@enterprisedb.com
Whole thread Raw
In response to Re: pg_stop_backup does not complete  (Josh Berkus <josh@agliodbs.com>)
Responses Re: pg_stop_backup does not complete  (Josh Berkus <josh@agliodbs.com>)
Re: pg_stop_backup does not complete  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: FW: Unable to install PostgreSQL on Windows Server 2003 SP2
Next
From: Greg Stark
Date:
Subject: Re: A thought on Index Organized Tables