A nightly pg_dump that fails with the reason, not with "Network is unreachable"

Munchable's Postgres runs on a hosted tier that provides no managed backups. That makes a nightly GitHub Actions job the only line of defence against data loss, so the workflow is intentionally simple...