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