Re: [GENERAL] default db

2007-05-22 Thread Hannes Dorbath
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 differen

Re: [GENERAL] default db

2007-05-22 Thread John D. Burger
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 y

[GENERAL] default db

2007-05-22 Thread Sandro Dentella
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 *:-) -