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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
