Your message dated Sun, 11 Dec 2005 14:54:00 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Bug#342369: do not build with integer timestamps
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 7 Dec 2005 15:38:30 +0000
>From [EMAIL PROTECTED] Wed Dec 07 07:38:30 2005
Return-path: <[EMAIL PROTECTED]>
Received: from trust-factory.com ([195.64.89.121]
helo=INTERPOL.trust-factory.com)
by spohr.debian.org with esmtp (Exim 4.50)
id 1Ek1NG-0001GJ-B9
for [EMAIL PROTECTED]; Wed, 07 Dec 2005 07:38:30 -0800
To: [EMAIL PROTECTED]
Subject: PostgreSQL 8.1.0 RHEL / Debian incompatible packages
MIME-Version: 1.0
X-Mailer: Lotus Notes Release 6.5.4 March 27, 2005
From: Richard van den Berg <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
Date: Wed, 7 Dec 2005 16:37:56 +0100
X-MIMETrack: Serialize by Router on INTERPOL/Trust-Factory(Release 6.5.4FP2 |
September
23, 2005) at 12/07/2005 16:38:29,
Serialize complete at 12/07/2005 16:38:29
Content-Type: multipart/alternative; boundary="=_alternative 0055D4B3C12570D0_="
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-4.9 required=4.0 tests=BAYES_00,HAS_PACKAGE,
HTML_20_30,HTML_MESSAGE autolearn=no
version=2.60-bugs.debian.org_2005_01_02
This is a multipart message in MIME format.
--=_alternative 0055D4B3C12570D0_=
Content-Type: text/plain; charset="US-ASCII"
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.
--=_alternative 0055D4B3C12570D0_=
Content-Type: text/html; charset="US-ASCII"
<br><font size=2 face="Courier New">Package: postgresql-8.1</font>
<br><font size=2 face="Courier New">Version: 8.1.0-3</font>
<br>
<br><font size=2 face="Courier New">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:</font>
<br>
<br><font size=2 face="Courier New">2005-12-07 11:55:04 CET FATAL:
database
files are incompatible with server</font>
<br><font size=2 face="Courier New">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.</font>
<br><font size=2 face="Courier New">2005-12-07 11:55:04 CET HINT: It
looks like you need to recompile or initdb.</font>
<br>
<br><font size=2 face="Courier New">The message is clear enough, but I'm
kinda disappointed because I am using the official packages for both
distribution:</font>
<br>
<br><font size=2 face="Courier New">RHEL 4:</font>
<br><font size=2 face="Courier New">postgresql-server-8.1.0-2PGDG.i686.rpm
from</font>
<br><font size=2 face="Courier
New">http://www.postgresql.org/ftp/binary/v8.1.0/linux/rpms/redhat/rhel-as-4/</font>
<br>
<br><font size=2 face="Courier New">Debian:</font>
<br><font size=2 face="Courier New">postgresql-8.1_8.1.0-3_i386.deb from</font>
<br><font size=2 face="Courier
New">http://packages.debian.org/testing/misc/postgresql-8.1</font>
<br>
<br><font size=2 face="Courier New">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.</font>
--=_alternative 0055D4B3C12570D0_=--
---------------------------------------
Received: (at 342369-done) by bugs.debian.org; 11 Dec 2005 13:54:32 +0000
>From [EMAIL PROTECTED] Sun Dec 11 05:54:32 2005
Return-path: <[EMAIL PROTECTED]>
Received: from box79162.elkhouse.de ([213.9.79.162])
by spohr.debian.org with esmtp (Exim 4.50)
id 1ElRep-0006zG-Ny
for [EMAIL PROTECTED]; Sun, 11 Dec 2005 05:54:31 -0800
Received: from localhost.localdomain (unknown [195.227.105.180])
(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
(Client CN "Martin Pitt (workstation)", Issuer "piware CA" (verified
OK))
by box79162.elkhouse.de (Postfix) with ESMTP id AD0C653C
for <[EMAIL PROTECTED]>; Sun, 11 Dec 2005 14:53:55 +0100 (CET)
Received: by localhost.localdomain (Postfix, from userid 1000)
id 26C041DE59; Sun, 11 Dec 2005 14:54:00 +0100 (CET)
Date: Sun, 11 Dec 2005 14:54:00 +0100
From: Martin Pitt <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Bug#342369: do not build with integer timestamps
Message-ID: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
protocol="application/pgp-signature"; boundary="jRHKVT23PllUwdXP"
Content-Disposition: inline
In-Reply-To: <[EMAIL PROTECTED]>
User-Agent: Mutt/1.5.11
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-2.4 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER,
RCVD_IN_BL_SPAMCOP_NET,RCVD_IN_SBLXBL,RCVD_IN_SBLXBL_CBL,
RCVD_IN_SORBS,RCVD_IN_SORBS_WEB autolearn=no
version=2.60-bugs.debian.org_2005_01_02
--jRHKVT23PllUwdXP
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Hi!
Peter Eisentraut [2005-12-10 1:23 +0100]:
> The integer timestamp option is definitely "better". The only reason=20
> it's not the default is that not all platforms have working 64-bit=20
> integer types. I don't see any reason to change the current=20
> compilation option; moving a data directory from a different operating=20
> system isn't supported anyway.
Thanks for clarifying. So it seems that there is no reason to ever
change this, thus I'm closing the bug now.
Martin
--=20
Martin Pitt http://www.piware.de
Ubuntu Developer http://www.ubuntu.com
Debian Developer http://www.debian.org
In a world without walls and fences, who needs Windows and Gates?
--jRHKVT23PllUwdXP
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
iD8DBQFDnC94DecnbV4Fd/IRAkNjAJ0XJXjWExm+bueiCKMOOE3TZay1UgCggGwH
B77gLJXRsM2Mh2k8+et+LC0=
=kzSO
-----END PGP SIGNATURE-----
--jRHKVT23PllUwdXP--
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
