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.unknown.charter.com
Whole thread Raw
In response to pg_stop_backup does not complete  (Josh Berkus <josh@agliodbs.com>)
Responses Re: pg_stop_backup does not complete
Re: pg_stop_backup does not complete
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: Josh Berkus
Date:
Subject: Re: pg_stop_backup does not complete
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_stop_backup does not complete