Hi!
VPS server has old Debian 6 Squeeze with Postgres 9.1
It has 24 databases.
Every night backup copies are created using pg_dump to /root/backups
directory for every database.
This directory has 24 .backup files with total size 37 GB.
I installed new VPS server with Debian 10 and Postgres 12.
How to transfer those databases to new server ?
Both server have ssh and root user, postgres port 5432 open, 100 MB
internet connection and fixed IP addresses. In night they are not used by
users, can stopped during move.
Should I download .backup files and use pg_restore or use pipe to restore
whole cluster.
Andrus.