Restore

Restore from backup file (.sql)

$ psql -U username -f filename.sql
Copy

// Restore database plain-text backup(.sql) generated by pg_dump or pg_dumpall with psql utility (psql)

Restore from custom archive backup file (.bak)

$ pg_restore -d db_name /path/to/your/file/db_name.bak -c -U db_user
Copy

// Restore database custom archive backup(.bak) using pg_restore utility (pg_restore)