Backup PostgreSQL database.

Write a PostgreSQL database backup as an SQL script using `pg_dump`.