video reference here you should try this , its worked fine thanks 

Hello this is Gulshan Negi

Well, the process of restoring a backup to a production database can be difficult and time-consuming. Before attempting to restore a backup, it is essential to follow the correct procedures for your particular database management system and to ensure that you have a backup of the production database. You can make sure that your data is restored correctly and that your production database is up and running smoothly with careful planning and execution.

Thanks

I tried from front-end( interface) but no seems "restore" option here. (ps: my account is still in trial mode, I didnot matched the licence subscription code yet) what you think?

Hi Daniel,

Case 1 : If you have taken the backup from odoo front-end(interface) then you can restore it from front-end interface.

Sample :  your_domain_url/web/database/manager there you can find the option called Restore.

Case 2: If you have taken the backup from postgresql db(backend) then the file will be having .out format and steps to restore the DB is as follows:

To Restore the database:

1. Drop the existing(old) DB (if there): drop database db_name.

2. Create a new database [CREATE DATABASE dbname;] ==> then come out of postgresql[ctrl+d]

3. Copy : Copy the .out file into the Destination psql

                 Destination : /var/lib/postgresql/

4. Restore : psql newly_created_db_name < filename123.out

Hope it will be helpful or you.