Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 280B42E0384 for ; Wed, 13 Feb 2008 12:57:34 -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 85916-05 for ; Wed, 13 Feb 2008 12:57:19 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.224]) by postgresql.org (Postfix) with ESMTP id 27F712E0372 for ; Wed, 13 Feb 2008 12:57:18 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 71so128032wri.5 for ; Wed, 13 Feb 2008 08:57:17 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=KKzqJW809OtojI7Wwqwq1+pKV2G71z9uLEzbuDGAn08=; b=ClSc7VS+/QzDpOi65cLKnCtRpXymJSVgoR72fzhu5KVqB0A6q7VRSPErRwQo9EdemVrPGAQicPABWsAw1zQRlDHyuJW7CYwWF2Uq81KwOka6+chi7KfSpHhaXNM2OSPlp0Noib812d2JDup7Vs7bpLVQpbCsza6QcvfBCUKw8AU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=inx4YUZJFY04+lvAnbK7Oe2lunuuRJs1sTGAB9rKXzJVfh8wl/+tTlPoQaMnnrVzsdln/cD7DsC2pBI0RKT2Jqz9XdsE9vJ5CzF3OrfvIBv5c5GP86HCCB5KmpJmWWB6k/M0LX5zEurMC1vjee8S1jmPO5iuvGv0VtEq5Oj0hJM= Received: by 10.140.251.1 with SMTP id y1mr96481rvh.107.1202921836673; Wed, 13 Feb 2008 08:57:16 -0800 (PST) Received: by 10.141.169.5 with HTTP; Wed, 13 Feb 2008 08:57:16 -0800 (PST) Message-ID: <684362e10802130857g48dead64u5dceb14cd1ebbf88@mail.gmail.com> Date: Wed, 13 Feb 2008 22:57:16 +0600 From: "Markus Bertheau" To: "Tena Sakai" Subject: Re: 8.3.0 upgrade, confused by documentation Cc: "Peter Childs" , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47B0A63A.9040807@otg-nc.com> <9999.1202765994@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/152 X-Sequence-Number: 28226 2008/2/13, Tena Sakai : > b) keep the 8.2.4 up and running, but via pg_hab.conf > make sure nobody can use the database. That's basically up to you, you can leave it open. The backup will be consistent, but it won't contain any changes made to the database after pg_dumpall has been started. > c) as user postgres, while environmental variables > PGHOST and PGPORT is set correctly, execute the > unix command below: > (path_to_8.3.0)/pg_dumpall > data_saved > Where I am fuzzy is step c). Ie., can I execute 8.3.0 > program (pg_dumpall) without running 8.3.0 postgreSQL? > And will it produce what I want? Yes, you can. It will connect to the 8.2.4 version. Markus