Cannot drop template1
От | Raymond O'Donnell |
---|---|
Тема | Cannot drop template1 |
Дата | |
Msg-id | 41BEEA2A.17170.48E437@localhost обсуждение исходный текст |
Ответы |
Re: Cannot drop template1
|
Список | 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@iol.ie Galway Cathedral Recitals -------------------------------------------------------------
В списке pgsql-general по дате отправления: