locale-gen just regenerates the locale - which I have. It's just that PostgreSQL doesn't see it. When I run locale-gen, it just shows that all locales (listed by locale -a) are "up to date".
depesz On Fri, Jun 6, 2014 at 10:04 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 06/06/2014 09:05 AM, hubert depesz lubaczewski wrote: > >> Hi, >> I'm running Pg 9.3.4 on Ubuntu Linux 12.04/Precise. Pg is installed from >> PGDG repo (http://apt.postgresql.org/pub/repos/apt/). >> >> It somehow got database created in locale that it can't now open: >> >> $ psql >> psql: FATAL: database locale is incompatible with operating system >> DETAIL: The database was initialized with LC_COLLATE "en_GB.UTF-8", >> which is not recognized by setlocale(). >> HINT: Recreate the database with another locale or install the missing >> locale. >> >> > >> The thing is that system knows about en_GB: >> >> > >> Is it possible? Anyone encountered something like this before? If so - >> what can be done? I didn't found any way to "unpack" the archive with >> locales. >> > > Seems this is a new Ubuntu thing: > > http://manpages.ubuntu.com/manpages/precise/man8/locale-gen.8.html > > and an example: > > http://backdrift.org/fixing-no-such-file-or-directory-locale-errors > > >> depesz >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >