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.org@mail.postgresql.org>;
	Mon, 20 Jun 2011 10:23:40 -0300 (ADT)
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.org@mail.postgresql.org>;
	Mon, 20 Jun 2011 13:23:34 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9])
	by mail.postgresql.org (Postfix) with ESMTP id 62240B5DBDD
	for <pgsql-admin@postgresql.org>; Mon, 20 Jun 2011 10:23:34 -0300 (ADT)
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
From: =?iso-8859-1?Q?Nils_G=F6sche?= <cartan@cartan.de>
To: <pgsql-admin@postgresql.org>
Subject: How to pg_upgrade an 8.4.3 Installation
Date: Mon, 20 Jun 2011 15:23:33 +0200
Message-ID: <011001cc2f4d$4114a100$c33de300$@de>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcwvTT6ruz1V4jqeRGOnyad54ir2bQ==
Content-Language: de
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-Archive-Number: 201106/119
X-Sequence-Number: 37745

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,
--=20
Nils G=F6sche
"Don't ask for whom the <CTRL-G> tolls."