Path: g2news1.google.com!news2.google.com!news.glorb.com!news.hub.org!postgresql.org!pgsql-admin-owner+M37745
From: car...@cartan.de (=?iso-8859-1?Q?Nils_G=F6sche?=)
Newsgroups: pgsql.admin
Subject: [ADMIN] How to pg_upgrade an 8.4.3 Installation
Date: Mon, 20 Jun 2011 15:23:33 +0200
Organization: Hub.Org Networking Services
Lines: 29
Sender: n...@news.hub.org
Message-ID: <011001cc2f4d$4114a100$c33de300$@de>
NNTP-Posting-Host: news.hub.org
Mime-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: news.hub.org 1308576230 98738 200.46.204.72 (20 Jun 2011 13:23:50 GMT)
X-Complaints-To: usenet@news.hub.org
NNTP-Posting-Date: Mon, 20 Jun 2011 13:23:50 +0000 (UTC)
Content-Language: de
X-Received: from mx1.hub.org (mx1.hub.org [200.46.208.106])
	by news.hub.org (8.14.4/8.14.4) with ESMTP id p5KDNo6H098704
	for <pgsql-ad...@news.hub.org>; Mon, 20 Jun 2011 10:23:50 -0300 (ADT)
	(envelope-from pgsql-admin-owner+M37...@postgresql.org)
X-Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
	by mx1.hub.org (Postfix) with ESMTP id AFCE127FB7E3;
	Mon, 20 Jun 2011 10:23:49 -0300 (ADT)
X-Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id CE629B5DBDF
	for <pgsql-admin-postgresql....@mail.postgresql.org>; Mon, 20 Jun 2011 10:23:40 -0300 (ADT)
X-Received: from mail.postgresql.org ([200.46.204.86])
 by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024)
 with ESMTP id 07109-06 for <pgsql-admin-postgresql....@mail.postgresql.org>;
 Mon, 20 Jun 2011 13:23:34 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9])
	by mail.postgresql.org (Postfix) with ESMTP id 62240B5DBDD
	for <pgsql-ad...@postgresql.org>; Mon, 20 Jun 2011 10:23:34 -0300 (ADT)
X-Received: from shor (mail.luratech.com [212.202.239.23])
	by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis)
	id 0MCMOD-1QPbuO2xwv-0090Lo; Mon, 20 Jun 2011 15:23:33 +0200
X-To: <pgsql-ad...@postgresql.org>
X-Mailer: Microsoft Office Outlook 12.0
X-Thread-Index: AcwvTT6ruz1V4jqeRGOnyad54ir2bQ==
X-Provags-ID: V02:K0:uWCcsZmjbf26+HV0apz7ZCqaQI2UInMg1XiWC8PhMLG
 r4H5XEFW5JTmHc5blCvd77SaGQl0TUG2+XMWeXcrmozZRYAM3q
 kf4YcdRWLRm0AFsOkY9RciMz1AFVKRU4NxA1klTMTVDn433IC8
 YQK49uPysap1ogh/OzuXlmrb7pWrVFePSDZBIT9/f0ed8nRKqz
 AXEQevKPIYgqLkNojC5og==
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
 RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Mailing-List: pgsql-admin
X-List-Archive: <http://archives.postgresql.org/pgsql-admin>
X-List-Help: <mailto:majord...@postgresql.org?body=help>
X-List-ID: <pgsql-admin.postgresql.org>
X-List-Owner: <mailto:pgsql-admin-ow...@postgresql.org>
X-List-Post: <mailto:pgsql-ad...@postgresql.org>
X-List-Subscribe: <mailto:majord...@postgresql.org?body=sub%20pgsql-admin>
X-List-Unsubscribe: <mailto:majord...@postgresql.org?body=unsub%20pgsql-admin>
X-Precedence: bulk
X-MIME-Autoconverted: from quoted-printable to 8bit by news.hub.org id p5KDNo6H098704

Hi!

I have an additional question about the pg_upgrade bugfix described in
http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix

Suppose I have an 8.4.3 installation somewhere which I want to upgrade to
9.0.4.

Can I simply use the 9.0.4 pg_upgrade on this since the bug has been fixed
in 9.0.4, or would I first have to upgrade the 8.4 installation to 8.4.8?
If so, would be it enough to simply replace the 8.4.3 binaries with 8.4.8
versions, or would I have to start and stop the server once?

The reason I am asking this is because I am going to do the upgrade
automatically in an installer, and if I could avoid the double upgrade, it
would simplify things.

Regards,
-- 
Nils G�sche
"Don't ask for whom the <CTRL-G> tolls."



-- 
Sent via pgsql-admin mailing list (pgsql-ad...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin