documentation vs reality: template databases

From: "Richard P(dot) Welty" <rwelty(at)averillpark(dot)net>
To: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: documentation vs reality: template databases
Date: 2007-01-11 21:30:59
Message-ID: 45A6AC93.2060000@averillpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

running 8.1 on a fedora core 5 linux box, up to date so far as
i know.

this page:

http://www.postgresql.org/docs/8.1/interactive/manage-ag-templatedbs.html

says the following:

Note: template1 and template0 do not have any special status beyond
the fact that the name template1 is the default source database name
for CREATE DATABASE. For example, one could drop template1 and
recreate it from template0 without any ill effects. This course of
action might be advisable if one has carelessly added a bunch of junk
in template1.

having just carelessly loaded a backup into template1 instead of the
place i wanted to load it, i had a chance to try to follow this advice:

foo=# drop database template1;
ERROR: cannnot drop a template database
foo=#

cheers,
richard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-11 21:32:42 Re: [HACKERS] Checkpoint request failed on version 8.2.1.
Previous Message Jeanna Geier 2007-01-11 21:20:09 Re: RESTORE Error