Hey all - my pg_control file got hosed somehow on a 7.1b3 installation. All my data files other than pg_control are intact. A search of the net reveals that the pg_resetxlog utility can be helpful in this situation. However, my installation does not have the pg_resetxlog utility in the contrib directory. So, I grabbed the 7.1.2 sources, built the utility in the contrib directory, and ran it. It seemed to run fine, but when I start postmaster now, I get: [vici:/usr/local/pgsql] postmaster FATAL 2: Invalid CRC in control file Next, I built and installed 7.1.2 over my 7.1b3 (I still have the 7.1b3 sources just in case). Now postmaster seems to start fine. But when I try to do a pg_dumpall, I get: [root@vici:/usr/local/pgsql] pg_dumpall -- -- pg_dumpall (7.1.2) -- \connect template1 DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0'); ERROR: readDatum: ']' expected, length = 12 DELETE FROM pg_group; -- -- Database template1 -- \connect template1 postgres \connect template1 postgres getDatabase(): SELECT failed. Explanation from backend: 'ERROR: readDatum: ']' expected, length = 12 '. pg_dump failed on template1, exiting When I run 'psql demo' at this point, I can issue commands like 'select * from person' and it gives me the header with the list of columns, but no data (0 rows). Attempting to describe a table results in an error much like the above. Seems to me the pg_resetxlog utility does not generate a pg_control file compatible with the 7.1b3 data file format, thus the CRC errors. It further appears that 7.1.2 is expecting a different format as well. I know all the data is there - it must be possible to extract it /somehow/. I would be _extremely_ grateful for any assistance. Thanks in advance. Alok ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
