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