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

Re: CREATE DATABASE fails when template1 being accessed ...

From: Alvaro Herrera <alvherre(at)surnet(dot)cl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: CREATE DATABASE fails when template1 being accessed ...
Date: 2005-05-31 20:01:00
Message-ID: 20050531200059.GD9257@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, May 31, 2005 at 02:49:09PM -0400, Tom Lane wrote:
> "Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
> > ERROR:  source database "template1" is being accessed by other users
> 
> > Why is this not allowed?
> 
> It's a rather lame attempt to ensure that you don't get a corrupt copy
> due to the database changing while you copy it ... I'd like to find
> a better way to do it ...

You sounded less enthusiastic about it on january:

http://archives.postgresql.org/pgsql-bugs/2005-01/msg00395.php

-- 
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Investigación es lo que hago cuando no sé lo que estoy haciendo"
(Wernher von Braun)

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-05-31 20:26:20
Subject: Quick-and-dirty compression for WAL backup blocks
Previous:From: Tom LaneDate: 2005-05-31 19:20:32
Subject: Re: Deadlock with tsearch2 index ...

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