Postgres Pro
Downloads
Home   >   mailing lists

Re: drop database / create database / data still here ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: drop database / create database / data still here ?
Date
Msg-id 12555.1271777333@sss.pgh.pa.us
Whole thread Raw
In response to drop database / create database / data still here ?  (Mitch Collinsworth <mitch@ccmr.cornell.edu>)
List pgsql-admin
Tree view 
Mitch Collinsworth <mitch@ccmr.cornell.edu> writes:
> [ a freshly created database has stuff in it ]

A freshly created database is, by default, a copy of "template1".
Apparently, you've accidentally created some stuff in template1.
Simplest solution is to connect to template1 and drop that stuff.

            regards, tom lane

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_restore -j
Next
From: Tom Lane
Date:
Subject: Re: pg_restore -j