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 9DC95535BB for ; Fri, 25 Mar 2005 19:32:04 +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 66613-08 for ; Fri, 25 Mar 2005 19:32:03 +0000 (GMT) Received: from blacksheep.csh.rit.edu (blacksheep.csh.rit.edu [129.21.60.6]) by svr1.postgresql.org (Postfix) with ESMTP id 89570535AC for ; Fri, 25 Mar 2005 19:32:02 +0000 (GMT) Received: from fury.csh.rit.edu (fury.csh.rit.edu [IPv6:2001:470:1f00:135:a00:20ff:fe8d:5399]) by blacksheep.csh.rit.edu (Postfix) with ESMTP id D972191FE; Fri, 25 Mar 2005 14:32:02 -0500 (EST) Received: by fury.csh.rit.edu (Postfix, from userid 20937) id A215914BF; Fri, 25 Mar 2005 14:32:02 -0500 (EST) Date: Fri, 25 Mar 2005 14:32:02 -0500 From: Matthew Wronkowski To: "Subbiah, Stalin" Cc: pgsql-admin@postgresql.org Subject: Re: 64 or 32 postgres Message-ID: <20050325193200.GB12505@csh.rit.edu> Mail-Followup-To: "Subbiah, Stalin" , pgsql-admin@postgresql.org References: <6B26A56846293C4488B54CF3E44033546CFF05@mxca2.corp.netopia.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6B26A56846293C4488B54CF3E44033546CFF05@mxca2.corp.netopia.com> X-Operating-System: SunOS 5.9 (sun4u) User-Agent: Mutt/1.5.3i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/421 X-Sequence-Number: 16919 On Fri, Mar 25, 2005 at 11:12AM -0800, I got a letter, where Subbiah, Stalin told me: > 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 Stalin, Probably the easiest way to figure out if the server is 64-bit is to run 'file postmaster' binary. However, the problem you are running into is because postgresql was configured/compiled with --enable-integer-datetimes enable 64-bit integer date/time support Recompile without this flag. -- Matthew Wronkowski, CCNP Bioinformatics Rochester Institute of Technology