Re: migrating data from an old postgres version

On 07/15/2016 07:26 AM, Melvin Davidson wrote:
>
> On Fri, Jul 15, 2016 at 10:24 AM, Willy-Bas Loos <willybas(at)gmail(dot)com
> <mailto:willybas(at)gmail(dot)com>> wrote:
>
> On Fri, Jul 15, 2016 at 4:19 PM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com