For restoring logical PostgreSQL dump use the standard `psql` tool. Detailed information can be found in the official PostgreSQL documentation
In general terms, the recovery order will be as follows: uncompress the backup (if the backup was compressed), then restore it using the `psql` tool.
Examples:
# Basic example
$ psql -h <psql_host> -U <psql_user> -W prod < /var/nxs-backup/db/psql12/prod/daily/psql12_prod_2022_07_31_01-01.sql# Decompress pipeline example
$ gunzip < /var/nxs-backup/db/psql12/prod/daily/psql12_prod_2022_07_31_01-01.sql.gz | psql -h <psql_host>
-U <psql_user> -W prod