Restore a PostgreSQL database from a backup file
psql -U username dbname < backup.sql
Restore database from file
psql -U postgres mydb < mydb_backup.sql