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@xxxxxxxxxxxxxxx Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
