Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 8.1.0 RHEL / Debian incompatible packages

From: Devrim GUNDUZ <devrim(at)commandprompt(dot)com>
To: Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-ports(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.1.0 RHEL / Debian incompatible packages
Date: 2005-12-07 13:54:49
Message-ID: 1133963689.14637.5.camel@devrim.kivi.com.tr (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-ports
Hi,
On Wed, 2005-12-07 at 12:14 +0100, Richard van den Berg wrote:
> 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:

Well, this is because Debian packages are built
with --enable-integer-datetimes. However we don't build the RPMs with
that. This has been proposed before AFAIR, but it has been rejected.

Also I want to remind that these packages are not "official". Debian
packages and RPMs are built by different people.

So you should dump/reload I think, or rebuild our SRPM
with --enable-integer-datetimes enabled.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/



In response to

pgsql-ports by date

Next:From: Martijn van OosterhoutDate: 2005-12-07 14:22:58
Subject: Re: PostgreSQL 8.1.0 RHEL / Debian incompatible packages
Previous:From: Richard van den BergDate: 2005-12-07 13:15:29
Subject: Re: PostgreSQL 8.1.0 RHEL / Debian incompatible packages

pgsql-general by date

Next:From: Hannes DorbathDate: 2005-12-07 13:57:38
Subject: TSearch2 / Get all unique lexems
Previous:From: Michelle KonzackDate: 2005-12-07 13:18:34
Subject: FW: Advanced search form

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group