Skip site navigation (1) Skip section navigation (2)

Error Starting Back END

From: "Rojas, Fernando \(CIAT\)" <f(dot)rojas(at)cgiar(dot)org>
To: Dirk Lutzebäck <lutzeb(at)aeccom(dot)com>,<pgsql-admin(at)postgresql(dot)org>,<pgsql-general(at)postgresql(dot)org>,<pgsql-bugs(at)postgresql(dot)org>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Error Starting Back END
Date: 2006-06-09 13:48:58
Message-ID: AACD86431269C546A6ECF51213C910D8133F89@ciatex8.CIAT.CGIARAD.ORG (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-general
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 

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Dirk Lutzebäck
Sent: Friday, June 09, 2006 8:26 AM
To: pgsql-admin(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org; pgsql-bugs(at)postgresql(dot)org
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: [ADMIN] How to set the global OID counter? COPY WITH OIDS does not set global OID counter?

Hi,

how can one set the global OID counter in 8.1.X? We think it would work in 8.0.X using the COPY WITH OIDS command but this does not work in 8.1.X anymore.

We have the problem that we made a dump using 'pg_dump -o' in 8.0.X, created a new database in 8.1.X and read back in but the global OID counter stayed at 40.000 so OIDs will be allocated again!

Thanks for help,

Dirk

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2006-06-09 14:00:15
Subject: Re: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?
Previous:From: Chris HooverDate: 2006-06-09 13:43:36
Subject: Re: Database port changing issue

pgsql-bugs by date

Next:From: Chris AchilliDate: 2006-06-09 13:59:05
Subject: BUG #2473: Failed to open RunAs Service
Previous:From: Dirk LutzebäckDate: 2006-06-09 13:25:55
Subject: How to set the global OID counter? COPY WITH OIDS does not set global OID counter?

pgsql-general by date

Next:From: Bill MoranDate: 2006-06-09 13:52:40
Subject: Re: 010.pgsql.sh does not react
Previous:From: pobox@verysmall.orgDate: 2006-06-09 13:48:33
Subject: Re: 010.pgsql.sh does not react

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group