X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 428C8534FA for ; Fri, 25 Mar 2005 19:12:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58460-10 for ; Fri, 25 Mar 2005 19:12:39 +0000 (GMT) Received: from mxca2.corp.netopia.com (host222.netopia.com [65.206.239.222]) by svr1.postgresql.org (Postfix) with ESMTP id 1216C534CB for ; Fri, 25 Mar 2005 19:12:38 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5316E.9C2736FE" Subject: 64 or 32 postgres Date: Fri, 25 Mar 2005 11:12:37 -0800 Message-ID: <6B26A56846293C4488B54CF3E44033546CFF05@mxca2.corp.netopia.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: 64 or 32 postgres Thread-Index: AcUxbpu7DfLrmRa3RjKeTeDDzf7FHQ== From: "Subbiah, Stalin" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.062 tagged_above=0 required=5 tests=AWL, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200503/420 X-Sequence-Number: 16918 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5316E.9C2736FE Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable How to figure out whether the installed postgres version is 32 bit or 64bit ? We installed postgres801 from src on susu box with EMT64 bit hardware. I assume since the hardware was 64 bit, postgres should have compiled in 64 bit too, but then we ran into this error FATAL: database files are incompatible with server DETAIL: The database cluster was initialized without HAVE_INT64_TIMESTAMP but the server was compiled with HAVE_INT64_TIMESTAMP. HINT: It looks like you need to recompile or initdb.=20 Any ideas ? Thanks, Stalin ------_=_NextPart_001_01C5316E.9C2736FE Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 64 or 32 postgres

How to figure out whether the = installed postgres version is 32 bit or 64bit ? We installed postgres801 = from src on susu box with EMT64 bit hardware. I assume since the = hardware was 64 bit, postgres should have compiled in 64 bit too, but = then we ran into this error

FATAL: database files are = incompatible with server
DETAIL: The database cluster was = initialized without HAVE_INT64_TIMESTAMP but the server was compiled = with HAVE_INT64_TIMESTAMP.

HINT: It looks like you need to = recompile or initdb.

Any ideas ?

Thanks,
Stalin

------_=_NextPart_001_01C5316E.9C2736FE--