We are in the process of trying to upgrade our DB from Postgres 9.5 to 14 and decided to use the postgres utility
pg_upgrade --link. This was left to run for over a day and we had to abort the process as the downtime was too drastic. The cause was determined to be the number of BLOBs contained in the database as even with the
--link option it had to dump and restore these objects. I've been looking into replication tools but many seem to either not work with BLOBs (ex. Slony), or can't operate between dbs of different versions.
Are there any Postgres utilities or 3rd party tools that could do this operation faster, or without bringing Postgres down?