from version 13 to version 16. pg_dump is not enough for my database size because it takes too long.
From Postgresql v13 to Postgresql v16 I may need two methods depending on the situation.
Here are the solution methods in my mind.
=> pgLoader, pg_dump for Offline Migration
=> Logical Replication for Online Migration
Do you have any suggestions for upgrading some databases to high version?
You can also use pg_upgrade to upgrade directly to the new version. It can handle 13 to 16 in one step. https://www.postgresql.org/docs/current/pgupgrade.html The other option is logical replication. But keep in mind not to run DDL statements, it might break the logical replication. Also a failover to a follower will hurt you if you aren't using a relatively new version of Patroni.
Обсуждают сегодня