Home > mailing lists

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

From	David G. Johnston
Subject	Re: migrating data from an old postgres version
Date	July 15, 2016 17:09:45
Msg-id	CAKFQuwY3MeaJNfv3NmofJVBLcBk_-2gYSEc98Kttxkf=DSWEHQ@mail.gmail.com Whole thread Raw
In response to	Re: migrating data from an old postgres version (Paul Ramsey <pramsey@cleverelephant.ca>)
Responses	Re: migrating data from an old postgres version
List	pgsql-general

On Fri, Jul 15, 2016 at 10:02 AM, Paul Ramsey <pramsey@cleverelephant.ca> 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.

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

David J.

From: Willy-Bas Loos
Date: 15 July 2016, 17:08:00
Subject: Re: migrating data from an old postgres version

From: Willy-Bas Loos
Date: 15 July 2016, 17:12:45
Subject: Re: migrating data from an old postgres version