Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

incorrect checksum in control file error for postgres 9.1.3 data created in osx-Lion and accessed in osx-snow-leopard

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?

like image 782
Pavan Avatar asked May 08 '12 09:05

Pavan


1 Answers

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.

like image 166
Chris Travers Avatar answered Jan 03 '23 10:01

Chris Travers