350 DBs with about 130 tables and a bunch of sequences each, for the sake of precision.
Aside of this, I'm having 350 DBs that sum up a bit more than 1 TB, and plan
to use wal_level=archive because I plan to have a backup server with barman.
With that many databases with that so many objects
Yes, that's another big problem... we run normally between 500 and 700 concurrent connections... I had to set max_connections=1000, the whole thing grew up faster than we were prepared for...and undoubtable client connections,
That will be step 2... while migration is running (and will run for some months, we have to plan migration with users) I'll test putting another one or two machines in cluster, make some test cases, and when ready, databases will be migrated on other machines, too.I'd want to spread that across a cluster of smaller servers.
ideas are always precious and welcome.just sayin...
-- john r pierce, recycling bits in santa cruz