PostgreSQL: restore database from .dump file

Trabla: PostgreSQL: restore database from .dump file

Solving:

pg_restore -d dbname filename

Official Docs:
http://www.postgresql.org/docs/9.1/static/backup-dump.html#BACKUP-DUMP-RESTORE

Real World Example:

pg_restore -U moodledbuser -h 127.0.0.1  -d moodle_db   moodle_backup.dump