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@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------