Re: migrating data from an old postgres version

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Fri, Jul 15, 2016 at 10:02 AM, Paul Ramsey <pramsey@xxxxxxxxxxxxxxxxx> wrote:

Make sure to pg_dump -Fc

(note the flags)

​You need to also include "​--quote-all-identifiers" if you intend for the dump to be restored onto a newer version of PostgreSQL.

https://www.postgresql.org/docs/9.6/static/app-pgdump.html

And don't forget pg_dumpall to get the globals - or to do the whole thing.

https://www.postgresql.org/docs/9.6/static/app-pg-dumpall.html

David J.