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@xxxxxxxxx Phone:(57-2)445-01-00 Ext 3647 -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Dirk Lutzebäck Sent: Friday, June 09, 2006 8:26 AM To: pgsql-admin@xxxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx; pgsql-bugs@xxxxxxxxxxxxxx Cc: tgl@xxxxxxxxxxxxx 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
