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