incorrect checksum in control file error for postgres 9.1.3 data created in osx-Lion and accessed in osx-snow-leopard
macos, postgresql, postgresql-9.1
Solution
You can't move between systems with different operating systems. The compiled versions may have different alignment etc. Do a dump on the old and a restore on the new.
Problem
I get the following error when trying to start postgres using the data created in another mac machine. FATAL: incorrect checksum in control file The postgres version is 9.1.3 and the data initialized in snow leopard does not work in Lion and vice-versa. I do not face this issue for postgres v9.0.1. is there any configuration in postgres 9.1.3 which fixes this issue?