From: | hubert depesz lubaczewski <depesz(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem with locales on Linux with 9.3.4 |
Date: | 2014-06-06 23:36:47 |
Message-ID: | CAKrjmhcrFhzZaj70NfQZZJ3ucb1U5Q9QUfthezZHGN-0f1wVFA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-06-06 23:55:48 | Re: Problem with locales on Linux with 9.3.4 |
Previous Message | Adrian Klaver | 2014-06-06 20:18:53 | Re: bytea Issue - Reg |