Re: Warm Standby Weirdness

Sam Nelson <samn@consistentstate.com> writes:
> Here's the output from pg_controldata:

> $ pg_controldata `pwd`
> 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:            843
> Catalog version number:               200904091
> Database system identifier:           5473004134245625319
> Database cluster state:               in production
> pg_control last modified:             Wed 31 Dec 1969 05:00:00 PM MST
> Latest checkpoint location:           B000020/0
> Prior checkpoint location:            A000020/0
> Latest checkpoint's REDO location:    B000020/1

This is just an educated guess, but I'm going to bet on 32-bit vs 64-bit.
Are you trying to copy the DB to a machine with different word size?
Won't work.

            regards, tom lane