Pgrestore

Global

Restore postgresql database

PGPASSWORD=<db_password> pg_restore -Fc -U <db_user> -d <db_name> <dump_file>

OR

pg_restore -Fc -d "postgresql://<db_user>:<db_password>@<db_host>:<db_port>/<db_name>" <dump_file>