The following bug has been logged online: Bug reference: 5327 Logged by: janandith Email address: janand...@gmail.com PostgreSQL version: 8.2.14 Operating system: windows 2003 Description: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows. Details:
After upgrading postgresql binaries from 8.2.6 to 8.2.14 in windows 2003 I cannot start the database using postgresql.exe because there is a checksum error. What I'm doing is building postgresql 8.2.14 from source code and replacing the binaries. In windows I'm building using MSYS and replacing existing .exe files. After the replacement Linux binaries are working without errors. But the windows binaries reads the Date/time type storage: and Locale wrong. It should be be floating-point and C locale but read as 64-bit integers and Locale as @. Following are the results of pg_controldata. Linux pg_control version number: 822 Catalog version number: 200611241 Database system identifier: 5219167662867643742 Database cluster state: in production pg_control last modified: Fri 12 Feb 2010 03:47:00 PM IST Current log file ID: 0 Next log file segment: 63 Latest checkpoint location: 0/3EA20688 Prior checkpoint location: 0/3E9F1084 Latest checkpoint's REDO location: 0/3EA20688 Latest checkpoint's UNDO location: 0/0 Latest checkpoint's TimeLineID: 1 Latest checkpoint's NextXID: 0/547350 Latest checkpoint's NextOID: 26232 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Time of latest checkpoint: Fri 12 Feb 2010 03:47:00 PM IST Minimum recovery ending location: 0/0 Maximum data alignment: 4 Database block size: 8192 Blocks per segment of large relation: 131072 WAL block size: 8192 Bytes per WAL segment: 16777216 Maximum length of identifiers: 64 Maximum columns in an index: 32 Date/time type storage: floating-point numbers Maximum length of locale name: 128 LC_COLLATE: C LC_CTYPE: C Windows WARNING: Calculated CRC checksum does not match value stored in file. Either the file is corrupt, or it has a different layout than this program is expecting. The results below are untrustworthy. pg_control version number: 822 Catalog version number: 200611241 Database system identifier: 5247545044375645930 Database cluster state: shut down pg_control last modified: 01.01.1970 01:00:00 Current log file ID: 1265884073 Next log file segment: 0 Latest checkpoint location: 0/30 Prior checkpoint location: 0/2F7CA1A8 Latest checkpoint's REDO location: 0/2F6F4E60 Latest checkpoint's UNDO location: 0/2F7CA1A8 Latest checkpoint's TimeLineID: 0 Latest checkpoint's NextXID: 0/1 Latest checkpoint's NextOID: 0 Latest checkpoint's NextMultiXactId: 173924 Latest checkpoint's NextMultiOffset: 17725 Time of latest checkpoint: 01.01.1970 01:00:01 Minimum recovery ending location: 0/4B73DBA9 Maximum data alignment: 0 Database block size: 8 Blocks per segment of large relation: 0 WAL block size: 0 Bytes per WAL segment: 1093850759 Maximum length of identifiers: 8192 Maximum columns in an index: 131072 Date/time type storage: 64-bit integers Maximum length of locale name: 16777216 LC_COLLATE: @ LC_CTYPE: -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
