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.