Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-07 Thread hubert depesz lubaczewski
localedef --no-archive, requires additional argument, and then it waits on something. I'm definitely not an locale expert, so I have no idea what it does. There is locale-gen option --no-archive, too, but when I run locale-gen --no-archive, I just get: # locale-gen --no-archive Generating

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-07 Thread Adrian Klaver
On 06/07/2014 08:17 AM, hubert depesz lubaczewski wrote: localedef --no-archive, requires additional argument, and then it waits on something. I'm definitely not an locale expert, so I have no idea what it does. There is locale-gen option --no-archive, too, but when I run locale-gen

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-07 Thread Adrian Klaver
On 06/07/2014 08:17 AM, hubert depesz lubaczewski wrote: localedef --no-archive, requires additional argument, and then it waits on something. I'm definitely not an locale expert, so I have no idea what it does. There is locale-gen option --no-archive, too, but when I run locale-gen

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-07 Thread hubert depesz lubaczewski
Seems I now have the locale. Too bad I had to delete the bad databases earlier. Thanks Adrian, depesz On Sat, Jun 7, 2014 at 7:16 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 06/07/2014 08:17 AM, hubert depesz lubaczewski wrote: localedef --no-archive, requires additional

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-07 Thread Adrian Klaver
On 06/07/2014 12:43 PM, hubert depesz lubaczewski wrote: Seems I now have the locale. Too bad I had to delete the bad databases earlier. So, just for completeness what worked: locale-gen sudo dpkg-reconfigure locales or localedef ? Thanks Adrian, depesz -- Adrian Klaver

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-07 Thread hubert depesz lubaczewski
localedef. depesz On Sat, Jun 7, 2014 at 9:57 PM, Adrian Klaver adrian.kla...@aklaver.com wrote: On 06/07/2014 12:43 PM, hubert depesz lubaczewski wrote: Seems I now have the locale. Too bad I had to delete the bad databases earlier. So, just for completeness what worked: locale-gen

[GENERAL] Problem with locales on Linux with 9.3.4

2014-06-06 Thread hubert depesz lubaczewski
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

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-06 Thread Adrian Klaver
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

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-06 Thread hubert depesz lubaczewski
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

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-06 Thread Adrian Klaver
On 06/06/2014 04:36 PM, hubert depesz lubaczewski wrote: 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. Did you do 'dpkg-reconfigure locales' after the

Re: [GENERAL] Problem with locales on Linux with 9.3.4

2014-06-06 Thread Adrian Klaver
On 06/06/2014 04:36 PM, hubert depesz lubaczewski wrote: 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. On further reading another way would be to use