Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AF685650288 for ; Mon, 20 Oct 2008 14:02:32 -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 22114-05-2 for ; Mon, 20 Oct 2008 14:02:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ipmail01.adl6.internode.on.net (ipmail01.adl6.internode.on.net [203.16.214.146]) by postgresql.org (Postfix) with ESMTP id 81F26650299 for ; Mon, 20 Oct 2008 14:02:27 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: ArMEAM8S9kjLevdH/2dsb2JhbAAsgUbANIFr X-IronPort-AV: E=Sophos;i="4.33,453,1220193000"; d="scan'208";a="214393385" Received: from ppp247-71.static.internode.on.net (HELO DevBox.local) ([203.122.247.71]) by ipmail01.adl6.internode.on.net with ESMTP; 21 Oct 2008 03:32:24 +1030 Message-ID: <48FCB99E.9000800@Sheeky.Biz> Date: Tue, 21 Oct 2008 03:32:22 +1030 From: Shane Ambler User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421) MIME-Version: 1.0 To: Martin Badie CC: pgsql 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> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200810/139 X-Sequence-Number: 30595 Martin Badie wrote: > Hi, > > 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? Of course I am thinking to make a dump but I wanted to ask > first because db is very huge (about 100 gb) The 32bit and 64bit will not read from the same data files. You will need to dump and restore to transfer the data across. -- Shane Ambler pgSQL (at) Sheeky (dot) Biz Get Sheeky @ http://Sheeky.Biz