I just tried to move my database files over from a CentOS 4.2 (RHEL AS 4
clone) machine to Debian 3.1. Unfortunately, the server complains:
2005-12-07 11:55:04 CET FATAL: database files are incompatible with server
2005-12-07 11:55:04 CET DETAIL: The database cluster was initialized
without HAVE_INT64_TIMESTAMP but the server was compiled with
HAVE_INT64_TIMESTAMP.
2005-12-07 11:55:04 CET HINT: It looks like you need to recompile or
initdb.
The message is clear enough, but I'm kinda disappointed because I am
using the official packages for both distribution:
RHEL 4:
postgresql-server-8.1.0-2PGDG.i686.rpm from
http://www.postgresql.org/ftp/binary/v8.1.0/linux/rpms/redhat/rhel-as-4/
Debian:
postgresql-8.1_8.1.0-3_i386.deb from
http://packages.debian.org/testing/misc/postgresql-8.1
It's too bad these two binary distributions are not compatible with
respect to the database files.
Is there a good reason that the official RPM on postgresql.org is not
build with HAVE_INT64_TIMESTAMP ? It would have been so nice if this
would have worked. :-/
Sincerely,
--
Richard van den Berg, CISSP
-------------------------------------------
Trust Factory B.V. | www.dna-portal.net
Bazarstraat 44a | www.trust-factory.com
2518AK The Hague | Phone: +31 70 3620684
The Netherlands | Fax : +31 70 3603009
-------------------------------------------