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 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 > sudo dpkg-r

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 adrian

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 wrote: > On 06/07/2014 08:17 AM, hubert depesz lubaczewski wrote: > >> localedef --no-archive, requires additional argument, and then it waits

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 --no-arc

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 --no-arc

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 lo

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

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 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 wrote: > On 06/06/2014 09:05 AM, hubert depesz lu

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 i