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

Re: Hot Standby and DROP DATABASE

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org, Tatsuo Ishii <ishii(at)postgresql(dot)org>
Subject: Re: Hot Standby and DROP DATABASE
Date: 2010-02-07 16:49:04
Message-ID: 1265561344.27207.35.camel@ebony (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, 2010-02-06 at 17:32 +0100, Andres Freund wrote:
> > 
> > So it seems at least the behavior is quite different from what the
> > docs stats. Am I missing something here?
> Its a small bug/typo in standby.c:ResolveRecoveryConflictWithDatabase
> 
> The line:
> 		CancelDBBackends(dbid, PROCSIG_RECOVERY_CONFLICT_TABLESPACE, true);
> 
> has to be
> 		CancelDBBackends(dbid, PROCSIG_RECOVERY_CONFLICT_DATABASE, true);

Well spotted, thanks for the report and the analysis.

The code for drop database worked when committed but it looks like the
re-factoring of the code broke it. Will fix.

-- 
 Simon Riggs           www.2ndQuadrant.com


In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2010-02-07 16:58:44
Subject: Re: pg_class has no toast table?
Previous:From: Tom LaneDate: 2010-02-07 16:44:38
Subject: Re: Precedence of Postfix operators

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