Creating a PostgreSQL database backup via psql on macOS – Stack Overflow

sudo -u postgres pg_dump mydb > db.sql

Source: django – Creating a PostgreSQL database backup via psql on macOS – Stack Overflow