Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?
Дата
Msg-id 527C1B91.4090204@gmail.com
обсуждение исходный текст
Ответ на Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?  (Greg Burek <gb@heroku.com>)
Ответы Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?  (Leonardo Carneiro <chesterman86@gmail.com>)
Список pgsql-general
On 11/07/2013 11:07 AM, Greg Burek wrote:
> On Wed, Nov 6, 2013 at 4:36 AM, Leonardo Carneiro
> <chesterman86@gmail.com <mailto:chesterman86@gmail.com>> wrote:
>
>     I don't think that there will be too much trouble, as long as you
>     follow every changelog tip (9.0->9.1, 9.1->9.2 and 9.2->9.3)
>
>
> What if we don't follow the changelog tip? In this case, we have only
> the 9.0 and 9.3 binaries installed and pg_upgrade directly to 9.3. Does
> that cause fear?

Not so much fear as concern. One of my rules is that the good will take
care of itself it is the bad you have to plan for. In this case it is
not the nine changes that do not impact your code but the one that does.
When going through the change logs the incompatibilities are listed at
the top under the  Migration to Version 9.* header. It does not take to
long to double check. If you want to save time just look at the major
version changes, i.e 9.X versus 9.X.x as incompatibilities are allowed
in major version changes. Not that they do not happen in minor releases,
but that is generally done to fix a security/major bug and I do not
recall any in the range you are looking at.

--
Adrian Klaver
adrian.klaver@gmail.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Curious question about physical files to store database
Следующее
От: Victor Hooi
Дата:
Сообщение: Breaking up a PostgreSQL COPY command into chunks?