Re: default db - Mailing list pgsql-general

From John D. Burger
Subject Re: default db
Date
Msg-id B635653F-3A05-431C-BD43-78BA9447A30B@mitre.org
Whole thread Raw
In response to default db  (Sandro Dentella <sandro@e-den.it>)
List pgsql-general
Sandro Dentella wrote:

>   I'm using debian and I don't understand how to create template1 on
>   installation of postgresql with a preferred encoding.
>
>   Is it safe to just dump/restore template1 with different encoding?

Or drop template1, and then recreate it from template0 with the
defaults you want.  I gather that's the point of template0.  See the
Fine Manual:

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

- John D. Burger
   MITRE



pgsql-general by date:

Previous
From: Sandro Dentella
Date:
Subject: default db
Next
From: Hannes Dorbath
Date:
Subject: Re: default db