PostgreSQL: custom dump for a small database
Custom format is useful because it can be listed and restored selectively.
pg_dump -Fc -f app_$(date +%F_%H%M).dump appdb
pg_restore -l app_*.dump | head
ls -lh app_*.dump
Verify the result
The file should not be empty, and pg_restore -l should list objects.