From: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Cannot drop template1 |
Date: | 2004-12-14 13:27:06 |
Message-ID: | 41BEEA2A.17170.48E437@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings all,
I'm trying to drop template1 so that I can re-create it from
template0 - I made the mistake of loading a whole pile of crud into
template1 (luckily it's a test installation on my WinXP Pro laptop).
However, when using -
dropdb -U postgres -W template1
at the command line, all I get back is "dropdb: database removal
failed: ERROR: cannot drop the currently open database". This is
even after a cold start; the DBMS service has only just been started
and is doing no other work whatsoever - there are no other
connections to template1 or indeed any other database.
I've tried connecting to a different database and dropping template1
from there, only to be told that I cannot drop a template database.
I've also tried connecting to template0, but was told that template0
is not accepting connections.
Any suggestions will be appreciated!
--Ray.
-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2004-12-14 13:49:17 | Re: Sheduler in Postgres |
Previous Message | Peter Haworth | 2004-12-14 12:12:04 | Re: Ridiculous load |