From: Greg Smith <greg@2ndQuadrant.com>
To: pgsql-admin@postgresql.org
Subject: Re: How to pg_upgrade an 8.4.3 Installation
Date: Mon, 20 Jun 2011 23:35:09 -0400
Message-ID: <4E00116D.50704@2ndQuadrant.com> (raw)
In-Reply-To: <011001cc2f4d$4114a100$c33de300$@de>
References: <011001cc2f4d$4114a100$c33de300$@de>
On 06/20/2011 09:23 AM, Nils Gösche wrote:
> 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?
>
Unless this 8.4 install was itself upgraded from 8.3 using pg_upgrade,
you can go right from 8.4.3 to 9.0.4.
The reason for the fix in 8.4.8 was to take care of people who use(d)
pg_upgrade to upgrade from 8.3 to 8.4. Those people needed 8.4.8
released with the bug fix in order to correct the problem that could be
in their 8.4 databases. If you did an 8.3->8.4 pg_upgrade on this
system before, you might want to do the standard fix suggested using
8.4.8. But if this has always been an 8.4 system, you can just go right
to 9.0.4.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: greg@2ndQuadrant.com
Subject: Re: How to pg_upgrade an 8.4.3 Installation
In-Reply-To: <4E00116D.50704@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox