Hello Tom, > If your platform doesn't make it easy to > have two versions installed concurrently, > one simple way to do this is to install > the newer PG code on another machine and > do the dump across the network.
I am using Dell Hardware on Redhat Enterprise Linux and wanting to go from 8.2.4 to 8.3.0. Would you please tell me where I might find documentation/references to run multiple versions of postgreSQL on one OS? Regards, Tena Sakai [EMAIL PROTECTED] -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Mon 2/11/2008 1:39 PM To: Chander Ganesan Cc: Tena Sakai; pgsql-admin@postgresql.org Subject: Re: [ADMIN] 8.3.0 upgrade, confused by documentation Chander Ganesan <[EMAIL PROTECTED]> writes: > Tena Sakai wrote: >> I am going from 8.2.4 to 8.3.0. Does, "For best results, >> however, try to use the pg_dumpall command from PostgreSQL >> 8.3.0" apply to me? >> > Yes. You want to use the 8.3.0 version of pg_dumpall. I don't think this is particularly critical for 8.2 to 8.3, but in cases where you're trying to jump multiple major versions in one step, it's often the case that it will go smoother with the later pg_dump. If your platform doesn't make it easy to have two versions installed concurrently, one simple way to do this is to install the newer PG code on another machine and do the dump across the network. regards, tom lane