locale problems

Lists: pgsql-admin
From: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: locale problems
Date: 2003-08-07 18:10:01
Message-ID: Pine.LNX.4.21.0308072003071.29353-100000@tiger.tigrasoft.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hi all!

I made a failure. I changed operating system under my database from Red
Hat 8.0 to Debian 3.0 (Woody), without pg_dump-ing the database. The
database version haven`t changed. Now I cannot start my database on the
same data directory, it stops with the following failure:

Failed to initialize lc_messages to ''
FATAL: invalid value for option 'LC_MESSAGES': 'en_US.UTF-8'
pg_ctl: cannot start postmaster
Examine the log output.

I tryed with modifying the postgresql.conf with a number of different
locale settings but they did not work. What is the shortest way to get my
database back? Should I install RedHat back?

Thanks,
Laszlo


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: locale problems
Date: 2003-08-07 18:27:57
Message-ID: Pine.LNX.4.56.0308072027150.1290@krusty.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin

Hornyak Laszlo writes:

> I made a failure. I changed operating system under my database from Red
> Hat 8.0 to Debian 3.0 (Woody), without pg_dump-ing the database. The
> database version haven`t changed. Now I cannot start my database on the
> same data directory, it stops with the following failure:
>
> Failed to initialize lc_messages to ''
> FATAL: invalid value for option 'LC_MESSAGES': 'en_US.UTF-8'
> pg_ctl: cannot start postmaster
> Examine the log output.

Install the en_US.UTF-8 locale on your system. Try "dpkg-reconfigure
locales".

--
Peter Eisentraut peter_e(at)gmx(dot)net


From: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: locale problems
Date: 2003-08-07 18:35:22
Message-ID: Pine.LNX.4.21.0308072034320.30871-100000@tiger.tigrasoft.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin


Cool :)

Thanks,
Laszlo

On Thu, 7 Aug 2003, Peter Eisentraut wrote:

> Hornyak Laszlo writes:
>
> > I made a failure. I changed operating system under my database from Red
> > Hat 8.0 to Debian 3.0 (Woody), without pg_dump-ing the database. The
> > database version haven`t changed. Now I cannot start my database on the
> > same data directory, it stops with the following failure:
> >
> > Failed to initialize lc_messages to ''
> > FATAL: invalid value for option 'LC_MESSAGES': 'en_US.UTF-8'
> > pg_ctl: cannot start postmaster
> > Examine the log output.
>
> Install the en_US.UTF-8 locale on your system. Try "dpkg-reconfigure
> locales".
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net
>