|
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@xxxxxxxxx]
On Sun, Jan 18, 2015 at 3:55 PM, Perry, Hemy <hemy_perry@xxxxxxxxxx> 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 |
