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 86F4453556 for ; Fri, 25 Mar 2005 19:36:50 +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 66789-09 for ; Fri, 25 Mar 2005 19:36:48 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4FFDE534CB for ; Fri, 25 Mar 2005 19:36:45 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2PJah1D011045; Fri, 25 Mar 2005 14:36:43 -0500 (EST) To: "Subbiah, Stalin" Cc: pgsql-admin@postgresql.org Subject: Re: 64 or 32 postgres In-reply-to: <6B26A56846293C4488B54CF3E44033546CFF05@mxca2.corp.netopia.com> References: <6B26A56846293C4488B54CF3E44033546CFF05@mxca2.corp.netopia.com> Comments: In-reply-to "Subbiah, Stalin" message dated "Fri, 25 Mar 2005 11:12:37 -0800" Date: Fri, 25 Mar 2005 14:36:43 -0500 Message-ID: <11044.1111779403@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/422 X-Sequence-Number: 16920 "Subbiah, Stalin" writes: > 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 That has nothing to do with 64/32 bit; you changed the --enable-integer-datetimes config option. regards, tom lane