Обсуждение: PostgreSQL version upgrade from 9.1 to 9.5

Поиск
Список
Период
Сортировка

PostgreSQL version upgrade from 9.1 to 9.5

От
Amar
Дата:

Hi there,


Apologies if my email is not relevant for this group. Please redirect me to correct list.


I am planning to upgrade PostgreSQL 9.1.x to 9.5.x, please can you suggest if I need to do anything difference while restoring data?


I’ll use pg_dump (9.1.x) for backup and restore using pg_restore (9.5.x)


Regards,

Amar

Re: PostgreSQL version upgrade from 9.1 to 9.5

От
Albe Laurenz
Дата:
Amar wrote:
> I am planning to upgrade PostgreSQL 9.1.x to 9.5.x, please can you suggest if I need to do anything
> difference while restoring data?
> 
> I’ll use pg_dump (9.1.x) for backup and restore using pg_restore (9.5.x)

Use pg_dump from 9.5 to dump the old database.

Read the release notes of all major releases (9.2, 9.3, 9.4, 9.5)
and look for behaviour changes / incompatibilities.
They might affect you.

Test!

Yours,
Lauernz Albe