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.
