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

From Willy-Bas Loos
Subject Re: migrating data from an old postgres version
Date
Msg-id CAHnozTg32xhAgRO3MscDkvsXsnH_4V89PEvUsrZgomi2HdY43g@mail.gmail.com
Whole thread Raw
In response to Re: migrating data from an old postgres version  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
On Fri, Jul 15, 2016 at 4:22 PM, Melvin Davidson <melvin6925@gmail.com> wrote:

As Adrian and I have said, pg_dump and pg_dumpall as backwards compatible and the recommended method for porrting data from one version
to another. You will NOT get errors if you use plain format.


I can't use plain.
And i've had errors with plain in this scenario before. Especially around sequences, that could be "OWNED BY" someone since 8.4 if i remember correctly.
But there were more things.
A new thing is  ERROR:  unrecognized configuration parameter "row_security" , but that doesn't reallyt do any harm.
But there's more that i don't remember, since i learned how to avoid them.

Thanks for your help though :)
--
Willy-Bas Loos

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: migrating data from an old postgres version
Next
From: Adrian Klaver
Date:
Subject: Re: migrating data from an old postgres version