From mboxrd@z Thu Jan 1 00:00:00 1970 From: Danny Milosavljevic Subject: Re: locales gone Date: Wed, 12 Oct 2016 22:37:33 +0200 Message-ID: <20161012223733.6e95ca41@scratchpost.org> References: <20160925233222.33804eb3@scratchpost.org> <87vaxe5197.fsf@gnu.org> <20161008160006.04ada83c@scratchpost.org> <87oa2rgbi9.fsf@gnu.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:56201) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1buQHb-0001pZ-FG for guix-devel@gnu.org; Wed, 12 Oct 2016 16:37:48 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1buQHX-0007e0-QP for guix-devel@gnu.org; Wed, 12 Oct 2016 16:37:46 -0400 In-Reply-To: <87oa2rgbi9.fsf@gnu.org> List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+gcggd-guix-devel=m.gmane.org@gnu.org Sender: "Guix-devel" To: Ludovic =?ISO-8859-1?Q?Court=E8s?= Cc: guix-devel@gnu.org 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.