From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Perumal Raj <perucinci(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Looking for Postgres upgrade Metrix |
Date: | 2019-07-17 18:22:09 |
Message-ID: | CAKFQuwaPjNg87Yiqxw43U++fOABv-YNeK54KVXf538aGFZHUnA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jul 17, 2019 at 11:16 AM Perumal Raj <perucinci(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-07-17 18:24:18 | Re: Looking for Postgres upgrade Metrix |
Previous Message | Alvaro Herrera | 2019-07-17 18:21:38 | Re: Corrupt index stopping autovacuum system wide |