Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 25C0F2E31BD for ; Mon, 11 Feb 2008 17:40:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 70010-01 for ; Mon, 11 Feb 2008 17:39:54 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 4B6152E002C for ; Mon, 11 Feb 2008 17:39:58 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1BLdsHp010000; Mon, 11 Feb 2008 16:39:54 -0500 (EST) To: Chander Ganesan cc: Tena Sakai , pgsql-admin@postgresql.org Subject: Re: 8.3.0 upgrade, confused by documentation In-reply-to: <47B0A63A.9040807@otg-nc.com> References: <47B0A63A.9040807@otg-nc.com> Comments: In-reply-to Chander Ganesan message dated "Mon, 11 Feb 2008 14:47:06 -0500" Date: Mon, 11 Feb 2008 16:39:54 -0500 Message-ID: <9999.1202765994@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/143 X-Sequence-Number: 28217 Chander Ganesan 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