Re: documentation vs reality: template databases

Richard P. Welty wrote:
> 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=#

This was written a while ago, but this gives you pretty detailed
instructions about how to fix this:

http://www.postgresql.org/docs/techdocs.22

--
Postgresql & php tutorials
http://www.designmagick.com/