public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: PG Dump on 11 - Restore on 16 - is possible?
Date: Tue, 13 Aug 2024 07:58:04 -0400
Message-ID: <CANzqJaB=_v+X-o8ubg5HniT4KH9gvsAAQHcDeJ65WoMK6kvJ1Q@mail.gmail.com> (raw)
In-Reply-To: <CAEcMXhmBGDWQnVwvhcg-2SPn4PM=PS+aZCouZiu=FEusevWskA@mail.gmail.com>
References: <CAEcMXhmBGDWQnVwvhcg-2SPn4PM=PS+aZCouZiu=FEusevWskA@mail.gmail.com>
On Tue, Aug 13, 2024 at 5:47 AM Durumdara <[email protected]> wrote:
> Hello!
>
> We have to upgrade our server. The PG upgrade is impossible because of too
> much data.
> So we will create a new server with PG 16, and we have to migrate the
> databases one by one (from a PG 11 server).
>
> Is it possible?
>
> Does PG16 read PG11 dumps and restore them correctly on the PG16 server?
>
https://www.postgresql.org/docs/release/16.0/
"See Section 19.6 <https://www.postgresql.org/docs/16/upgrading.html; for
general information on migrating to new major releases."
Section 19.6: https://www.postgresql.org/docs/16/upgrading.html
"Current releases of the dump programs can read data from any server
version back to 9.2."
The major flaw in Section 19.6 is that it repeatedly says "use pg_dumpall",
and only mentions pg_dump once. Don't use pg_dumpall; use pg_dump in
"directory mode" with multiple threads. ("pg_dumpall --globals" is
critical for roles and whatnot.)
This is how I recently migrated three multi-TB PG 9.6 RHEL6 servers to PG
14 on RHEL8.
--
Death to America, and butter sauce.
Iraq lobster!
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: PG Dump on 11 - Restore on 16 - is possible?
In-Reply-To: <CANzqJaB=_v+X-o8ubg5HniT4KH9gvsAAQHcDeJ65WoMK6kvJ1Q@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox