Hi,

In the current case, you can directly restore the database from the UI or use terminals

If you restore the dump dile try this code in your terminal

$sudo su postgres

$createdb -O [Owner] [database_name]

$psql [database_name]

dump:

$sudo su postgres

$createdb -O [Owner] [database_name]

$pgrestore -d [database_name] [dumpfile_name].dump

for more reference you can refer to the Blog : 

https://www.cybrosys.com/blog/how-to-restore-a-database-in-odoo-15-erp

automatic datarestore-

https://www.cybrosys.com/blog/how-to-setup-automatic-database-backup-in-odoo-15

Hope it helps