| From: | mail(at)localhorst(dot)es |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Different encodings and locales on one machine |
| Date: | 2021-03-04 08:40:26 |
| Message-ID: | a08646b59be303a9a3ffa21f72436b90@localhorst.es |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
at the moment I am running two different PostgreSQL (12) servers on one
Ubuntu 20.04 machine.
For server one I need WIN1252 encoding with "de_DE.cp1252" locales set.
For server two I need UTF8 encoding, but also with "de_DE.cp1252"
locales set.
I added support for
de_DE.CP1252 CP1252
de_DE.CP1252 UTF-8
to
/usr/local/share/i18n/SUPPORTED
and
/etc/locale.gen
and ran
locale-gen
PostgreSQL seems only to recognize the last entry I added. So I can
either use "WIN1252" or "UTF-8" encoding with "de_DE.cp1252" locales.
Maybe I just have problems understanding how Liunx is handling encodings
and locales.
Does anyone is successfully running PostgreSQL with a similar setup as I
described?
Kind regards,
Patrick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2021-03-04 12:14:03 | Re: Different encodings and locales on one machine |
| Previous Message | stephanhahn | 2021-03-03 14:36:07 | Re: make postgres readonly |