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

Re: pg_stop_backup does not complete

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_stop_backup does not complete
Date: 2010-02-23 17:52:19
Message-ID: 1266947539.1766.18.camel@jd-desktop.unknown.charter.com (view raw or flat)
Thread:
Lists: 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.


In response to

Responses

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2010-02-23 17:56:31
Subject: Re: pg_stop_backup does not complete
Previous:From: Josh BerkusDate: 2010-02-23 17:49:34
Subject: Re: pg_stop_backup does not complete

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