Re: pg_dump from older version and pg_restore in newer

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(at)gmail(dot)com]
Sent: 18 January 2015 13:03
To: Perry, Hemy
Cc: pgsql-admin(at)postgresql(dot)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(at)mentor(dot)com<mailto:hemy_perry(at)mentor(dot)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
www.shreeyansh.com<http://www.shreeyansh.com>