| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Greg Stark <gsstark(at)mit(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: DROP DATABASE, but still there |
| Date: | 2004-11-11 21:14:20 |
| Message-ID: | 11627.1100207660@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greg Stark <gsstark(at)mit(dot)edu> writes:
> Robert Fitzpatrick <robert(at)webtent(dot)com> writes:
>> Yeah, I was just starting to realize that these objects that keep coming
>> back are in the template1 as well.....any reason why I shouldn't drop
>> the template1 and re-create like any other?
> You can do that but you'll have to do:
> CREATE DATABASE template1 WITH template = 'template0'
Also there are several safety interlocks you'll have to defeat, IIRC.
It's not rocket science but I'd recommend consulting the writeup on
techdocs.postgresql.org about the exact process for recreating
template1.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Woodchuck Bill | 2004-11-11 21:37:21 | Re: I resign as the promoter of the PostgreSQL groups. |
| Previous Message | Dawid Kuroczko | 2004-11-11 21:03:48 | Re: comp.database.postgresql.* |