PostgreSQL: do not forget roles during migration
Plain pg_dump does not save global roles and tablespaces.
pg_dumpall --globals-only > globals.sql
pg_dump -Fc -f app.dump appdb
head -n 40 globals.sql
Verify the result
Check roles in globals.sql before restoring.