Skip site navigation (1) Skip section navigation (2)

Re: pg_stop_backup does not complete

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Simon Riggs <simon(at)2ndQuadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_stop_backup does not complete
Date: 2010-02-24 20:18:02
Message-ID: 4B85897A.2040408@enterprisedb.com (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2010-02-24 20:25:54
Subject: Re: A thought on Index Organized Tables
Previous:From: Richard HuxtonDate: 2010-02-24 20:15:37
Subject: Re: FW: Unable to install PostgreSQL on Windows Server 2003 SP2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group