What's your preferred way of migrating postgres databases?
Hi, as I learn about and work with Postgres I will have to do some db migrations.
Most of my servers are managed Postgres but also some are on-prem on vms.
Anyway, when you are asked to migrate Postgres databases, what's your goto procedure?
Backup/restore?
Logical replication?
Cloud based migration services?
u/A55Man-Norway — 2 days ago