Re: Problem with locales on Linux with 9.3.4

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(dot)klaver(at)aklaver(dot)com