how to restore postgresql database from a backup file

 in order to restore a postgresql database based on a backup file, use a command line (cmd) and enter the following code:

pg_restore -h localhost -p 5432 -U postgres -d testdatabse -v d:\db.backup

with 

localhost: your host name

5432: the used port for postgresql

testdatabase: the new database in which you want to retore you backup file

d:\db.backup: the database backup file.

don't hesitate to write your feedback or comment