Re: DROP DATABASE, but still there - Mailing list pgsql-general

From Doug McNaught
Subject Re: DROP DATABASE, but still there
Date
Msg-id 87k6ssyzrd.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to DROP DATABASE, but still there  (Robert Fitzpatrick <robert@webtent.com>)
Responses Re: DROP DATABASE, but still there
List pgsql-general
Robert Fitzpatrick <robert@webtent.com> writes:

> What does it mean when you drop a database and then recreate with the
> same name and all the objects are still there. I want to wipe out the db
> and put back from pg_restore. After I re-create the db, all the old
> tables are back before I run pg_restore.

Check the 'template1' database to see if the tables got put in there
by mistake at some point.

-Doug

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: making another super user other than postgres
Next
From: Tom Lane
Date:
Subject: Re: Analyse - max_locks_per_transaction - why?