template1 problems - Mailing list pgsql-general

From Sim Zacks
Subject template1 problems
Date
Msg-id dagl4m$2ekg$1@news.hub.org
Whole thread Raw
List pgsql-general
Postgresql 8.0 Linux. using PGAdmin III 1.2 client

I accidentally did a restore of my database into template1. I thought the
best way to reverse it would be to drop the database and make a new one with
template0 as the template. But it didn't like that because template1 is a
system database so I can't drop it.

Is there a better way of fixing this then going through and deleting all the
objects one at a time?

Thanks
Sim



pgsql-general by date:

Previous
From: D A GERM
Date:
Subject: Re: double entries into database when using IE
Next
From: Nikolay Samokhvalov
Date:
Subject: suggestion for diagnostics (errors)