incorrect checksum in control file

[Jeffrey W. Baker]

Today I tried to move a database and got this error, which I gather is
very rare (also undocumented):

postgres[2767]: [1-1] FATAL: incorrect checksum in control file

I moved the database from a 32-bit arch to a 64-bit arch. All I did was
shutdown a 7.4.1 database, shutdown the machine, swap the storage onto
the 64-bit machine running 7.4.5, and try to restart. No dice.

Any suggestions? I copied the entire $PGDATA tree, reinitialized, and
restored from a dump.

-jwb

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

"Jeffrey W. Baker" <jw*****@acm.org> writes:

I moved the database from a 32-bit arch to a 64-bit arch. All I did was
shutdown a 7.4.1 database, shutdown the machine, swap the storage onto
the 64-bit machine running 7.4.5, and try to restart. No dice.

You're fortunate that it died that quickly, rather than corrupting your
data in weird and wonderful ways. Postgres has never been designed to
have architecture-independent data files.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match