Re: CREATE DATABASE vs delayed table unlink - Mailing list pgsql-hackers

From Matthew Wakeling
Subject Re: CREATE DATABASE vs delayed table unlink
Date
Msg-id alpine.DEB.1.10.0810091345280.15851@aragorn.flymine.org
Whole thread Raw
In response to Re: CREATE DATABASE vs delayed table unlink  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: CREATE DATABASE vs delayed table unlink
List pgsql-hackers
On Thu, 9 Oct 2008, Tom Lane wrote:
> So I'm mystified
> how Matthew could have seen the expected error and yet had the
> destination tree (or at least large chunks of it) left behind.

Remember I was running 8.3.0, and you mentioned a few changes after that 
version which would have made sure the destination tree was cleaned up 
properly.

> [ thinks for a bit... ]  We know there were multiple occurrences.
> Matthew, is it possible that you had other createdb failures that
> did *not* report "file does not exist"?  For instance, a createdb
> interrupted by a "fast" database shutdown might have left things this
> way.

Well, we didn't have any fast database shutdowns or power failures. I 
don't think so.

Matthew

-- 
Heat is work, and work's a curse. All the heat in the universe, it's
going to cool down, because it can't increase, then there'll be no
more work, and there'll be perfect peace.      -- Michael Flanders


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum and reloptions
Next
From: Michael.McMaster@wrsa.com.au
Date:
Subject: bytea to XML crash fix