Re: Proposal: improve shutdown during online backup - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Proposal: improve shutdown during online backup
Date
Msg-id 1206564667.4285.1223.camel@ebony.site
Whole thread Raw
In response to Proposal: improve shutdown during online backup  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-hackers
On Wed, 2008-03-26 at 14:36 +0100, Albe Laurenz wrote:
> I'm referring to the discussion in this thread:
> http://archives.postgresql.org/pgsql-hackers/2007-11/msg00946.php
> 
> As expressed in the thread, I think that there should not be
> a backup_label file in the data directory after a clean shutdown,
> because
> a) it's probably an oversight anyway (someone forgot to
>    call pg_stop_backup) and
> b) it will force an unnecessary recovery at server restart,
>    which will sometimes fail (if the WAL file is no longer there).
> 
> This is my proposal:
> 
> 1) On "pg_ctl stop|restart -m smart", check if online backup is
>    in progress and do not shutdown in this case (treat the online
>    backup like an open connection).
> 2) On "pg_ctl stop|restart -m fast", remove backup_label after
>    the server has been brought down successfully.
> 
> If that's acceptable, I'd be willing to work on it.

Seems reasonable. Go for it.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com 
 PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk



pgsql-hackers by date:

Previous
From: "Gurjeet Singh"
Date:
Subject: Re: HELP
Next
From: Chris Browne
Date:
Subject: Re: Sending queries directly