Search Postgresql Archives

Re: migrating data from an old postgres version

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: migrating data from an old postgres version
From: Willy-Bas Loos <willybas@xxxxxxxxx>
Date: Fri, 15 Jul 2016 16:14:53 +0200
Cc: Paul Ramsey <pramsey@xxxxxxxxxxxxxxxxx>, Melvin Davidson <melvin6925@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CAKFQuwY3MeaJNfv3NmofJVBLcBk_-2gYSEc98Kttxkf=DSWEHQ@mail.gmail.com>

On Fri, Jul 15, 2016 at 4:09 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

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

Hey that's new, i'll be sure to use it!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- migrating data from an old postgres version
  - From: Willy-Bas Loos
- Re: migrating data from an old postgres version
  - From: Melvin Davidson
- Re: migrating data from an old postgres version
  - From: Paul Ramsey
- Re: migrating data from an old postgres version
  - From: David G. Johnston

Prev by Date: Re: migrating data from an old postgres version
Next by Date: Re: pg_restore out of memory
Previous by thread: Re: migrating data from an old postgres version
Next by thread: Re: migrating data from an old postgres version
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux