Re: restoring 9.3 dump file to 9.6

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: rajan <vgmonnet(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: restoring 9.3 dump file to 9.6
Date: 2016-12-02 14:41:47
Message-ID: e371d05a-c4c2-9095-f392-e20994e1e0f2@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 12/2/16 2:27 AM, rajan wrote:
> I have a dump created from pg 9.3. Will there be any difficulties in
> restoring that dump file to 9.6?

The recommended way is to use the pg_dump from 9.6 to dump from the 9.3
server. Then it should work.

If you use the pg_dump from 9.3, there might be minor problems. It's
best to try it out first.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc-Olaf Jaschke 2016-12-05 14:52:50 Re: Some questions about old_snapshot_threshold
Previous Message rajan 2016-12-02 07:27:31 restoring 9.3 dump file to 9.6