Hi,

I see that the default encoding for a db is taken from template1.

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?

TIA
*:-)


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

On 22.05.2007 14:02, Sandro Dentella wrote:
> I see that the default encoding for a db is taken from template1.
>
> 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?

Default encoding is taken from the cluster locale. Debian sure has some
fancy wrapper scripts for that, but

initdb -D $PGDATA --locale='en_US.utf8'

is the command to create a new cluster with another locale. Chose one
from locale -a


--
Regards,
Hannes Dorbath

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/i...ive/manage-ag-
templatedbs.html

- John D. Burger
MITRE



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings