Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump from older version and pg_restore in newer - Mailing list pgsql-admin

From Perry, Hemy
Subject Re: pg_dump from older version and pg_restore in newer
Date
Msg-id CCA7F829407A9D46B8358520B195A929CE71B61F@EU-MBX-04.mgc.mentorg.com
Whole thread Raw
In response to Re: pg_dump from older version and pg_restore in newer  (Shreeyansh dba <shreeyansh2014@gmail.com>)
List pgsql-admin
Tree view

Aitla, thank you very much for the prompt reply!

The fact that I saw this sentence “Be sure to use pg_dump from the *new* version to take the dump from the old database.” more than once made me wonder if I am not missing something.

Thanks

Hemy

 

 

From: Shreeyansh dba [mailto:shreeyansh2014@gmail.com]
Sent: 18 January 2015 13:03
To: Perry, Hemy
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] pg_dump from older version and pg_restore in newer

 

 

 

On Sun, Jan 18, 2015 at 3:55 PM, Perry, Hemy <hemy_perry@mentor.com> wrote:

Hi,

 

I am planning  a migration from 9.1.7 to 9.4.0.

On many threads I noticed that the recommendation is “Be sure to use pg_dump from the *new* version to take the dump from the old database.”

 

Is that a must?

Is there a chance that a restore using new version will fail because the dump was taken with *old* bin?

 

Regards

Hemy

 

 

Hi Hemy,

 

Using of new version dump is not a must. You can use dump of Older version(9.1.7) and use restore of New version(9.4.0)

 

Using restore of new version will not fail because the dump was taken with *old* bin.

 

This can fail only if you give any wrong syntax in command.

 

 

Hope this clears your issue.

 

 

-

Thanks & Regards,

Venkataramana Aitla

Database Administrator

pgsql-admin by date:

Previous
From: Shreeyansh dba
Date:
Subject: Re: pg_dump from older version and pg_restore in newer
Next
From: Scott Ribe
Date:
Subject: Re: pg_dump from older version and pg_restore in newer