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
restore postgres database in Odoo
Jeevachaithanyan Sivanandan - May 14 - 
