Postgres Pro
Downloads
Home   >   mailing lists

Re: restoring 9.3 dump file to 9.6 - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: restoring 9.3 dump file to 9.6
Date
Msg-id e371d05a-c4c2-9095-f392-e20994e1e0f2@2ndquadrant.com
Whole thread Raw
In response to restoring 9.3 dump file to 9.6  (rajan <vgmonnet@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: rajan
Date:
Subject: restoring 9.3 dump file to 9.6
Next
From: Marc-Olaf Jaschke
Date:
Subject: Re: Some questions about old_snapshot_threshold