Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2E73B64FD6F for ; Mon, 20 Oct 2008 13:45:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15428-01 for ; Mon, 20 Oct 2008 13:44:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id EB1AB64FD27 for ; Mon, 20 Oct 2008 13:44:54 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 20 Oct 2008 11:44:52 -0500 Message-Id: <48FC6F27.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Mon, 20 Oct 2008 11:44:39 -0500 From: "Kevin Grittner" To: "pgsql" , "Martin Badie" Subject: Re: 32bit data on 64bit machine? References: <12366.76709.qm@web59904.mail.ac4.yahoo.com> In-Reply-To: <12366.76709.qm@web59904.mail.ac4.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200810/138 X-Sequence-Number: 30594 >>> Martin Badie wrote: > I have a 64 bit machine that has 32 bit pgsql rpms (8.2.5) installed. If I > install 64 bit of the same version does that create any problems? They can co-exist with no problem. When you are running multiple instances of PostgreSQL on the same box, you usually want to use different port numbers. If it's going to be a long-term thing, I highly recommend a different OS user ID own the data directory for each instance. (I wouldn't do that just for a conversion, though.) > Of course I am thinking to make a dump Right. We have been converting databases from 32-bit to 64-bit by first updating the OS to 64 bit, then later using pg_dumpall piped to psql on the same box. It's been working great. -Kevin