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