FW: Error starting backend

______________________________________________
From:   Rojas, Fernando (CIAT) 
Sent:   Wednesday, June 14, 2006 10:42 AM
To:     'pgsql-admin@postgresql.org'
Subject:        FW: Error starting backend

HELLO    I need some help for this…

Thanks

______________________________________________
From:   Rojas, Fernando (CIAT) 
Sent:   Thursday, June 08, 2006 2:48 PM
To:     'pgsql-admin@postgresql.org'
Subject:        FW: Error starting backend

______________________________________________
From:   Rojas, Fernando (CIAT) 
Sent:   Tuesday, June 06, 2006 12:29 PM
To:     'pgsql-admin@postgresql.org'
Cc:     'jason@DOMAIN.HIDDEN'
Subject:        Error starting backend

HELLO:

I have now an error similar to one posted under the subject:

We had format the DISK and reinstall the SO (Red Hat Linux 8.0 3.2-7); we don't have a pg_dumpall file of support; but we have

The copy of the data file that was running ok under (PG-8.0.7).
We reinstall P.G 8.0.7 and try to start post-master with the database cluster but have this error in the log:

FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"
FATAL:  invalid value for parameter "lc_messages": "en_US.UTF-8"

When I change the postgresql.conf file changing en_US.UTF-8  by C; the error dissapears but show me this another:

FATAL:  database files are incompatible with operating system
DETAIL:  The database cluster was initialized with LC_COLLATE "en_US.UTF-8", which is not recognized by setlo
cale().
HINT:  It looks like you need to initdb or install locale support

When I run:

Locale obtain this:
[root@gene4 data]# locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

But when I locale - a the result is:

[root@gene4 data]# locale -a
C
POSIX
en_AU
en_AU.utf8
en_BW
en_BW.utf8
en_CA
en_CA.utf8
en_DK
en_DK.utf8
en_GB
en_GB.iso885915
en_GB.utf8
en_HK
en_HK.utf8
en_IE
en_IE.utf8
en_IE.utf8@euro
en_IE@euro
en_IN
en_NZ
en_NZ.utf8
en_PH
en_PH.utf8
en_SG
en_SG.utf8
en_US
en_US.iso885915
en_US.utf8
en_ZA
en_ZA.utf8
en_ZW
en_ZW.utf8

I don't see en_US.UTF-8 there   why..??

I have tried doing initdb to an empty cluster  and copying the data folder  but the erros is the same.

Could you help me to resolve this..

Thank you very much for your colaboration.

FERNANDO ROJAS
Ingeniero de Sistemas y Computación
Unidad de Sistemas de Información
Centro Internacional de Agricultura Tropical (CIAT)
E-mail: frojas@cgiar.org
Phone:(57-2)445-01-00 Ext 3647