#1121672 postgresql-common: pg_upgradecluster -m dump is too slow. Please consider making -m upgrade a new default

#1121672#5
Date:
2025-11-30 12:56:30 UTC
From:
To:
pg_dump/pg_restore is very slow. It might take days if upgrading relatively
small cluster of 200Gb. (I got one from persoinal using of matrix-synapse for
several years, so even a single person can have cluster that big now)

My suggestion is either completely make `-m upgrade` a new default, or add new
method `auto` that will use either `dump` of `upgrade` depending on cluster
size.

pg_upgrade is safe and fast, and is widely used in production, and I see no
reason for not using it all the time by default.

And since `pg_upgradecluster` is started while upgrading the system, I would
also suggest to add a menu that asks for upgrade method. May be

And since I both perl developer and deal with PostgreSQL core code on regular
basis I can provide patches for these functionality, if Debian PostgreSQL
Maintainers approve the idea.