| From: | Gabriele Bartolini <gabriele(dot)bartolini(at)2ndQuadrant(dot)it> |
|---|---|
| To: | mark <dvlhntr(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: locales and encodings Oh MY! |
| Date: | 2010-11-12 07:45:07 |
| Message-ID: | 4CDCF083.2040004@2ndQuadrant.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-hackers |
Hi Mark,
Il 12/11/10 03:31, mark ha scritto:
> I have listed what I think I will be doing with regards to initdb. if anyone
> sees problems with the following mixture during my dump -> init-> restore I
> would be most keen in hearing about it.
FYI, PostgreSQL 8.4 introduced database level collation. Before that,
yes, you need to re-init your data dir.
> initdb /path/to/data/dir --lc_ctype=C --lc_collation=C
> --lc_message=en_US.UTF8 --lc_monetary=en_US.UTF8 --lc_numeric=en_US.UTF8
> --lc_time=en_US.UTF8 -E UTF8
Maybe you meant --lc_collate ?
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele(dot)bartolini(at)2ndQuadrant(dot)it | www.2ndQuadrant.it
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aimé Mukuma | 2010-11-12 11:29:30 | FW: How to replicate postgresql 8.2.9 on two servers on using linux fedora core 7. |
| Previous Message | mark | 2010-11-12 02:31:51 | locales and encodings Oh MY! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yeb Havinga | 2010-11-12 08:14:57 | Re: wCTE behaviour |
| Previous Message | Magnus Hagander | 2010-11-12 06:20:58 | Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |