Cannot drop template1

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
-------------------------------------------------------------

Responses

Browse pgsql-general by date

  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