BUG #5327: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows.

From: "janandith" <janandith(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5327: postgresql gives checksum error when upgrading 8.2.6 binaries to 8.2.14 in windows.
Date: 2010-02-15 08:36:11
Message-ID: 201002150836.o1F8aB6f038575@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5327
Logged by: janandith
Email address: janandith(at)gmail(dot)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:

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2010-02-15 09:40:36 Re: [BUGS] BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION
Previous Message Zdenek Kotala 2010-02-15 07:11:03 Re: BUG #5318: Inconsistent PHP pg_result_error_field PGSQL_DIAG_SOURCE_FUNCTION across instalations