Create a backup of a PostgreSQL database
pg_dump -U username dbname > backup.sql
Backup database to file
pg_dump -U postgres mydb > mydb_backup.sql