Re: default db

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: Sandro Dentella <sandro(at)e-den(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: default db
Date: 2007-05-22 12:59:33
Message-ID: B635653F-3A05-431C-BD43-78BA9447A30B@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • default db at 2007-05-22 12:02:52 from Sandro Dentella

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2007-05-22 13:09:06 Re: default db
Previous Message Sandro Dentella 2007-05-22 12:02:52 default db