public inbox for [email protected]help / color / mirror / Atom feed
PG Dump on 11 - Restore on 16 - is possible? 3+ messages / 3 participants [nested] [flat]
* PG Dump on 11 - Restore on 16 - is possible? @ 2024-08-13 09:47 Durumdara <[email protected]> 2024-08-13 09:53 ` Re: PG Dump on 11 - Restore on 16 - is possible? Kashif Zeeshan <[email protected]> 2024-08-13 11:58 ` Re: PG Dump on 11 - Restore on 16 - is possible? Ron Johnson <[email protected]> 0 siblings, 2 replies; 3+ messages in thread From: Durumdara @ 2024-08-13 09:47 UTC (permalink / raw) To: pgsql-general 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? Or is it unsupported now? Thank you! Best regards dd ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PG Dump on 11 - Restore on 16 - is possible? 2024-08-13 09:47 PG Dump on 11 - Restore on 16 - is possible? Durumdara <[email protected]> @ 2024-08-13 09:53 ` Kashif Zeeshan <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Kashif Zeeshan @ 2024-08-13 09:53 UTC (permalink / raw) To: Durumdara <[email protected]>; +Cc: pgsql-general Hi On Tue, Aug 13, 2024 at 2:47 PM 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? > PG provides backward compatibility so you can restore PG11 backup to PG16. > > Or is it unsupported now? > > Thank you! > > Best regards > dd > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PG Dump on 11 - Restore on 16 - is possible? 2024-08-13 09:47 PG Dump on 11 - Restore on 16 - is possible? Durumdara <[email protected]> @ 2024-08-13 11:58 ` Ron Johnson <[email protected]> 1 sibling, 0 replies; 3+ messages in thread From: Ron Johnson @ 2024-08-13 11:58 UTC (permalink / raw) To: pgsql-general 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! ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-13 11:58 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-08-13 09:47 PG Dump on 11 - Restore on 16 - is possible? Durumdara <[email protected]> 2024-08-13 09:53 ` Kashif Zeeshan <[email protected]> 2024-08-13 11:58 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox