Re: Problem with locales on Linux with 9.3.4

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Problem with locales on Linux with 9.3.4
Дата
Msg-id CAKrjmhcrFhzZaj70NfQZZJ3ucb1U5Q9QUfthezZHGN-0f1wVFA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem with locales on Linux with 9.3.4  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Problem with locales on Linux with 9.3.4
Re: Problem with locales on Linux with 9.3.4
Список 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.klaver@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.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: bytea Issue - Reg
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Problem with locales on Linux with 9.3.4