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

From Joshua D. Drake
Subject Re: pg_stop_backup does not complete
Date
Msg-id 1266947539.1766.18.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to pg_stop_backup does not complete  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Tue, 2010-02-23 at 09:45 -0800, Josh Berkus wrote:
> Simon, Fujii, All:
> 
> While demoing HS/SR at SCALE, I ran into a problem which is likely to be
> a commonly encountered bug when people first setup HS/SR.  Here's the
> sequence:
> 
> 1) Set up a brand new master with an archive-commmand and archive=on.
> 
> 2) Start the master
> 
> 3) Do a pg_start_backup()
> 
> 4) Realize, based on log error messages, that I've misconfigured the
> archive_command.
> 
> 5) Attempt to shut down the master.  Master tells me that pg_stop_backup
> must be run in order to shut down.

If I issue a shutdown, PostgreSQL should do whatever it needs to do to
shutdown; including issuing a pg_stop_backup. 

Joshua D. Drake




-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: pg_stop_backup does not complete
Next
From: Tatsuo Ishii
Date:
Subject: Re: function side effects