restore postgres database in Odoo

To restore the database gzip file to a database,

gunzip < backup_database.sql.gzip  | psql -d <db_name> 

if you want to restore from .sql file then

psql -d new_database_name -f /path/to/your/sql/file.sql