Re: pg_upgrade 9.0 to 9.6

From: Mikhail <bemewe(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_upgrade 9.0 to 9.6
Date: 2016-12-14 11:35:24
Message-ID: 1481715324.394617510@f27.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas, very handy page, thanks for the link.

If I understand it correctly, ideally the upgrade process should look like:
9.0.x --> 9.0.23 + recommended fixes (the main is about table's relfrozenxid)
9.0.23 --> 9.4.5 (as the last version, where 9.0.23 was supported)
9.4.5 --> 9.4.10 + fixes
9.4.10 --> 9.6.1

>Wednesday, December 14, 2016 12:55 PM +03:00 from Thomas Kellerer <spam_eater(at)gmx(dot)net>:
>
>Mikhail schrieb am 13.12.2016 um 10:57:
>> Should i check all the production environments for the problems,
>> mentioned in all interim versions release notes, is it enough only to
>> check the last minor upgrade release note (9.6 --> 9.6.1) or there is
>> another quick way to check if i should apply some additional actions
>> to standard pg_upgrade+stats_collect?
>
>There is a nice page which consolidates all release notes:
>
>    https://bucardo.org/postgres_all_versions.html
>
>The nice thing about that is, that for each change in one release, it also mentions if that was a change in other releases too, e.g.:
>
>    https://bucardo.org/postgres_all_versions.html#version_9.6.1
>
>Thomas
>
>
>
>
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general



In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shakti Singh 2016-12-14 13:19:00 PostgreSQL 9.6.1: Debug window does not load function sql
Previous Message Matija Lesar 2016-12-14 10:54:11 Negative numbers to DOMAIN casting