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

The short answer is that you should not be changing any build
configurations if changing from one minor release to another.  Are you
sure you are using the same build setup?

---------------------------------------------------------------------------

janandith wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5327
> Logged by:          janandith
> Email address:      janandith@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

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +