Re: locales gone

[Danny Milosavljevic]

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.