From martinbadie@yahoo.com Mon Oct  20 12:23:03 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E3F9E6501F2
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 20 Oct 2008 09:23:03 -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 41897-06 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 20 Oct 2008 09:22:51 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from n2a.bullet.mail.ac4.yahoo.com (n2a.bullet.mail.ac4.yahoo.com
	[76.13.13.65]) by postgresql.org (Postfix) with SMTP id 9E6D264FE63
	for <pgsql-admin@postgresql.org>; Mon, 20 Oct 2008 09:22:49 -0300 (ADT)
Received: from [76.13.13.25] by n2.bullet.mail.ac4.yahoo.com with NNFMP;
	20 Oct 2008 12:22:45 -0000
Received: from [76.13.10.169] by t4.bullet.mail.ac4.yahoo.com with NNFMP;
	20 Oct 2008 12:22:45 -0000
Received: from [127.0.0.1] by omp110.mail.ac4.yahoo.com with NNFMP;
	20 Oct 2008 12:22:45 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 424681.5485.bm@omp110.mail.ac4.yahoo.com
Received: (qmail 89587 invoked by uid 60001); 20 Oct 2008 12:22:45 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=fbeqKzDN/pkxC1LTYbUUz2z8tJscWaX1cBFUTg5G/fKDP3+xRrsihLOGqs7XYAaXpTiCqo7C8Fammx87DEHDGq/PIulFogk2OO97RlmlPyeG5zl1Dvc/zUloEI6WJwvTsBaLp+fw4Jqxt6hAnRPAPmsi/sc9CmjabrBRRDFvLrg=;
X-YMail-OSG: 
 ITdf_YgVM1mNVUvxsEByBKCRE6Zx2_uN5VUDktrMmeZaEeZh8kcm8LJ0_bO.9E5U48aHDDx.iNMlbmhpqsOK1gE1pm7ec.qo7u1bQ85zuB.PxVi94L1FOM1TuY7hF6mvI7Jt.ZrGqstBN_z5H0oK06w5gec-
Received: from [213.194.109.2] by web59904.mail.ac4.yahoo.com via HTTP;
	Mon, 20 Oct 2008 05:22:44 PDT
X-Mailer: YahooMailRC/1096.40 YahooMailWebService/0.7.218.2
Date: Mon, 20 Oct 2008 05:22:44 -0700 (PDT)
From: Martin Badie <martinbadie@yahoo.com>
Subject: 32bit data on 64bit machine?
To: pgsql <pgsql-admin@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-636871495-1224505364=:76709"
Message-ID: <12366.76709.qm@web59904.mail.ac4.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200810/134
X-Sequence-Number: 30590

--0-636871495-1224505364=:76709
Content-Type: text/plain; charset=us-ascii

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)

Regards?


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--0-636871495-1224505364=:76709
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi,<br><br>I have a 64 bit machine that has 32 bit pgsql rpms (8.2.5) installed. If&nbsp; 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)<br><br>Regards?<br></div></div><br>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com </body></html>
--0-636871495-1224505364=:76709--




From Kevin.Grittner@wicourts.gov Mon Oct  20 16:45:05 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 2E73B64FD6F
	for <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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" <Kevin.Grittner@wicourts.gov>
To: "pgsql" <pgsql-admin@postgresql.org>,
	"Martin Badie" <martinbadie@yahoo.com>
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 <martinbadie@yahoo.com> 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



From pgsql@Sheeky.Biz Mon Oct  20 17:02:32 2008
Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id AF685650288
	for <pgsql-admin-postgresql.org@postgresql.org>;
	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
	<pgsql-admin-postgresql.org@postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <pgsql@Sheeky.Biz>
User-Agent: Thunderbird 2.0.0.14 (Macintosh/20080421)
MIME-Version: 1.0
To: Martin Badie <martinbadie@yahoo.com>
CC: pgsql <pgsql-admin@postgresql.org>
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