Re: Database in use?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database in use?
Date: 2009-03-02 21:23:33
Message-ID: 28543.1236029013@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Carol Walter <walterc(at)indiana(dot)edu> writes:
> Well, most recently I had created a new database using UTF8 encoding
> and I had restored data to it, that had been in a database using
> SQL_ASCII. I wanted to rename the original database. When I tried to
> rename it, I got the message that I couldn't do it because the
> database was in use. This particular database is in a 8.2.4 release.
> I'm moving to 8.3.n but I'm not there yet.

OK. Consulting the CVS history, I see that RENAME DATABASE does have
a delay in it, but only in 8.3.x.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Chander Ganesan 2009-03-02 21:38:46 Re: Implementing PITR
Previous Message Carol Walter 2009-03-02 20:50:11 Re: Database in use?