Re: Cannot drop template1 - Mailing list pgsql-general

From Tom Lane
Subject Re: Cannot drop template1
Date
Msg-id 14206.1103034430@sss.pgh.pa.us
Whole thread Raw
In response to Cannot drop template1  ("Raymond O'Donnell" <rod@iol.ie>)
Responses Re: Cannot drop template1  ("Raymond O'Donnell" <rod@iol.ie>)
List pgsql-general
"Raymond O'Donnell" <rod@iol.ie> 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

pgsql-general by date:

Previous
From: Együd Csaba (Freemail)
Date:
Subject: Re: Insufficient memory for this operation.
Next
From: Robert Treat
Date:
Subject: Re: Best practice in postgres