For restoring the physical PostgreSQL dump use the standard `pg_restore` 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 `pg_restore` tool.
Examples:
# Decompress dump
$ gunzip /var/nxs-backup/db/psql13/daily/psql13_2022_08_02_01-01.tar.gz# Restoration of full dump (if you a performed backups of all databases)
# If database already exists:
$ pg_restore -U postgres -d prod <
/var/nxs-backup/db/psql13/daily/psql13_2022_08_02_01-01.tar# If database doesn't exists:
$ pg_restore -U postgres -C -d prod <
/var/nxs-backup/db/psql13/daily/psql13_2022_08_02_01-01.tar