PostgreSQL version upgrade from 9.1 to 9.5
PostgreSQL version upgrade from 9.1 to 9.5
От:
Amar <amarno1@gmail.com>
Дата:
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 <laurenz.albe@wien.gv.at>
Дата:
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