| From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
|---|---|
| To: | Sandro Dentella <sandro(at)e-den(dot)it> |
| Subject: | Re: default db |
| Date: | 2007-05-22 13:09:06 |
| Message-ID: | 4652EB72.1040508@theendofthetunnel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2007-05-22 14:09:30 | Re: Lock table, Select for update and Serialization error |
| Previous Message | John D. Burger | 2007-05-22 12:59:33 | Re: default db |