Re: Looking for Postgres upgrade Metrix - Mailing list pgsql-general

From David G. Johnston
Subject Re: Looking for Postgres upgrade Metrix
Date
Msg-id CAKFQuwaPjNg87Yiqxw43U++fOABv-YNeK54KVXf538aGFZHUnA@mail.gmail.com
Whole thread Raw
In response to Looking for Postgres upgrade Metrix  (Perumal Raj <perucinci@gmail.com>)
List pgsql-general
On Wed, Jul 17, 2019 at 11:16 AM Perumal Raj <perucinci@gmail.com> wrote:
Hi Team,

Do we have any reference link which explain various  upgrade path ( Direct / indirect) by using pg_upgrade or latest utility.

I hope pg_dump can be used from any lower version to Higher version. Please correct me if I am wrong.

From the v11 documentation:

Because pg_dump is used to transfer data to newer versions of PostgreSQL, the output of pg_dump can be expected to load into PostgreSQL server versions newer than pg_dump's version. pg_dump can also dump from PostgreSQL servers older than its own version. (Currently, servers back to version 8.0 are supported.) However, pg_dump cannot dump from PostgreSQL servers newer than its own major version; it will refuse to even try, rather than risk making an invalid dump. Also, it is not guaranteed that pg_dump's output can be loaded into a server of an older major version — not even if the dump was taken from a server of that version. Loading a dump file into an older server may require manual editing of the dump file to remove syntax not understood by the older server. Use of the --quote-all-identifiers option is recommended in cross-version cases, as it can prevent problems arising from varying reserved-word lists in different PostgreSQL versions.

David J.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Corrupt index stopping autovacuum system wide
Next
From: Adrian Klaver
Date:
Subject: Re: Looking for Postgres upgrade Metrix