[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: locales gone
From: |
Danny Milosavljevic |
Subject: |
Re: locales gone |
Date: |
Wed, 12 Oct 2016 22:37:33 +0200 |
Hi,
I read the docs you pointed me to - however, previously this worked fine as-is.
Also, I have a database that is inaccessible because the locale suddenly
(sometimes) doesn't work anymore. It's not like I can change what locale it was
created in without a time machine :)
$ psql -U postgres template1
psql: FATAL: database locale is incompatible with operating system
DETAIL: The database was initialized with LC_COLLATE "en_US.UTF-8", which is
not recognized by setlocale().
HINT: Recreate the database with another locale or install the missing locale.
Also,
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL: database
locale is incompatible with operating system
DETAIL: The database was initialized with LC_COLLATE "en_US.UTF-8", which is
not recognized by setlocale().
HINT: Recreate the database with another locale or install the missing locale.
........ hmm.
$ ls /run/current-system/locale/2.23/
ca_ES.utf8 en_CA.utf8 es_ES.utf8 fr_FR.utf8 nl_NL.utf8 tr_TR.utf8
cs_CZ.utf8 en_GB.utf8 es_MX.utf8 ga_IE.utf8 pl_PL.utf8 uk_UA.utf8
da_DK.utf8 en_US.utf8 fi_FI.utf8 it_IT.utf8 pt_PT.utf8 vi_VN.utf8
de_DE.utf8 en_US.UTF-8 fr_BE.utf8 ja_JP.utf8 ro_RO.utf8 zh_CN.utf8
el_GR.utf8 es_AR.utf8 fr_CA.utf8 ko_KR.utf8 ru_RU.utf8
en_AU.utf8 es_CL.utf8 fr_CH.utf8 nb_NO.utf8 sv_SE.utf8
$ export LC_COLLATE=en_US.UTF-8
$ python3
Python 3.4.3 (default, Jan 1 1970, 00:00:01)
[GCC 4.9.3] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import locale
>>> locale.setlocale(locale.LC_COLLATE, "")
'en_US.utf8'
$ psql -U postgres template1
psql: FATAL: database locale is incompatible with operating system
DETAIL: The database was initialized with LC_COLLATE "en_US.UTF-8", which is
not recognized by setlocale().
HINT: Recreate the database with another locale or install the missing locale.
- Re: locales gone, Danny Milosavljevic, 2016/10/08
- Re: locales gone, Ludovic Courtès, 2016/10/10
- Re: locales gone,
Danny Milosavljevic <=
- Re: locales gone, Ludovic Courtès, 2016/10/13
- Re: locales gone, Danny Milosavljevic, 2016/10/13
- Re: locales gone, Ludovic Courtès, 2016/10/14
- Re: locales gone, Danny Milosavljevic, 2016/10/15
- Re: locales gone, Danny Milosavljevic, 2016/10/15
- Re: locales gone, Danny Milosavljevic, 2016/10/15
- Re: locales gone, Ludovic Courtès, 2016/10/17
- Re: locales gone, Leo Famulari, 2016/10/17
- Re: locales gone, Ludovic Courtès, 2016/10/18