Package: postgresql-8.1
Version: 8.1.0-3
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
In the discussion here: http://groups.google.com/group/pgsql.ports/browse_frm/thread/b0eae040ec4f976e/d8e7ba7413818791 Tom Lane suggested I'd ask the Debian maintainer why the package is build using --enable-integer-datetimes since this is not the default.
- Bug#342369: PostgreSQL 8.1.0 RHEL / Debian incompatib... Richard van den Berg
