Re: 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> 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>*