Re: [GENERAL] Cannot drop template1

2004-12-17 Thread Raymond O'Donnell
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

Re: [GENERAL] Cannot drop template1

2004-12-13 Thread Tom Lane
"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 te

[GENERAL] Cannot drop template1

2004-12-13 Thread Raymond O'Donnell
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