Re: [GENERAL] Cannot drop template1
On 14 Dec 2004 at 9:27, Tom Lane wrote: See the article on techdocs.postgresql.org about rebuilding template1 to find out about all the gotchas and workarounds needed to do this. Found it - thanks! --Ray. - Raymond O'Donnell http://www.galwaycathedral.org/recitals [EMAIL PROTECTED] Galway Cathedral Recitals - ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
[GENERAL] Cannot drop template1
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 [EMAIL PROTECTED] Galway Cathedral Recitals - ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] Cannot drop template1
Raymond O'Donnell [EMAIL PROTECTED] writes: 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. That's because the dropdb command itself connects to template1. See the article on techdocs.postgresql.org about rebuilding template1 to find out about all the gotchas and workarounds needed to do this. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly