Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL version upgrade from 9.1 to 9.5 - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: PostgreSQL version upgrade from 9.1 to 9.5
Date
Msg-id A737B7A37273E048B164557ADEF4A58B538668F8@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to PostgreSQL version upgrade from 9.1 to 9.5  (Amar <amarno1@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Amar
Date:
Subject: PostgreSQL version upgrade from 9.1 to 9.5
Next
From: Travis Kirstine
Date:
Subject: superuser_reserved_connections and max_connections