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



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

Reply via email to