PostgreSQL 8.1.0 RHEL / Debian incompatible packages

From: Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-ports(at)postgresql(dot)org
Subject: PostgreSQL 8.1.0 RHEL / Debian incompatible packages
Date: 2005-12-07 11:14:05
Message-ID: 4396C3FD.3000902@trust-factory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-ports

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
-------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2005-12-07 11:30:17 Re: Character encoding and string matches
Previous Message Volkan YAZICI 2005-12-07 11:09:45 Re: Letting a function return multiple columns instead of a single complex ones

Browse pgsql-ports by date

  From Date Subject
Next Message Devrim GUNDUZ 2005-12-07 11:34:15 Re: PostgreSQL 8.1.0 RHEL / Debian incompatible packages
Previous Message Ilias Goudaropoulos 2005-12-04 19:45:22 Re: Attention of all PostgreSQL 8.1.0-2 Windows Installer