FW: Error starting backend

> ______________________________________________
> From: Rojas, Fernando (CIAT)
> Sent: Wednesday, June 14, 2006 10:42 AM
> To: 'pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org'
> Subject: FW: Error starting backend
>
>
>
> ______________________________________________
> From: Rojas, Fernando (CIAT)
> Sent: Tuesday, June 06, 2006 12:29 PM
> To: 'pgsql-admin(at)postgresql(dot)org'
> Cc: 'jason(at)DOMAIN(dot)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(at)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(at)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(dot)utf8(at)euro
> en_IE(at)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(at)cgiar(dot)org
> Phone:(57-2)445-01-00 Ext 3647
>