Thread: locale problems
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
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@gmx.net >
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@gmx.net