I am looking to upgrade our Postgres 9.6 server to Postgres 13.
I have looked into the following options:
pg_upgrade, if I was doing this without the
--linkoption, this would take considerable time and also a lot of unreclaimable disk space, the databases totals 1.1TB, so to do such a task I would need double the amount of disk.
PG Dump and Restore - I could utilize pg_dumpall however to do 1.1TB of databases would take considerable time to backup and restore to a new server.
What is the most efficient way to ensure minimal downtime when doing upgrade from pg 9.6 to 13. I can get a new server and install PG 13 and just dump and restore as mentioned above but that would take time.
I have looked into pglogical also but not entirely sure if this will give me what I need.
Any help is much appreciated.