Re: migrating data from an old postgres version - Mailing list pgsql-general

On 07/15/2016 07:26 AM, Melvin Davidson wrote:
>
> On Fri, Jul 15, 2016 at 10:24 AM, Willy-Bas Loos <willybas@gmail.com
> <mailto:willybas@gmail.com>> wrote:
>
>     On Fri, Jul 15, 2016 at 4:19 PM, Adrian Klaver
>     <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>
>         pg_dump is backwards compatible to version 7.0.
>
>
>     Yes but is it forward compatible from 7.0?
>     I mean can i restore a dump made with pg_dump 7.0 on a 9.4 database?
>
>     --
>     Willy-Bas Loos
>
>
> Yes, That is the whole point of backwards compatability!  That is how
> upgrades are done.

I think you are misunderstanding.  Willy is asking if you use the 7.0
version of pg_dump to dump a 7.0 database, can you then restore that
dump to a 9.4 database?

>
> --
> *Melvin Davidson*
> I reserve the right to fantasize.  Whether or not you
> wish to share my fantasy is entirely up to you.


--
Adrian Klaver
adrian.klaver@aklaver.com