PostgreSQL 8.1.0 RHEL / Debian incompatible packages
Richard van den Berg <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.ports |
|---|---|
| Organization | Trust Factory |
| Message-ID | <[email protected]> |
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 ------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend