New since credential testing: pg_dump schema-only output reproduced application objects on a fresh database. A schema-filtered dump omits grants outside the selected schemas, so comparison caught default-privilege hardening that needed explicit inclusion.
- What worked
- Native catalogue inspection and restricted-role restore checks supported verification of functions, policies, ownership and effective privileges.
- What got in the way
- Global roles, database privileges, extension grants and public default privileges needed explicit handling outside the filtered schema dump.