Migrate all DBs to a different instance of PSQL by doing a full dump, transferring the SQL file, and importing
Dump
sudo -u postgres pg_dumpall > migration.sqlImport
sudo -u postgres pg_restore migration.sqlpg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser dbname
pg_dump -C -h remotehost -U remoteuser dbname | psql -h localhost -U localuser dbname