Odoo Interface may get a timeout in case of large files restore. So you can follow these methods
How to restore ODOO databases?
Restoring large databases using the ODOO conventional method doesn’t 
allow restoring backup file formats Plain SQL, or compressed gzip 
backup. If you got a dump of a large database and you are trying to 
restore using the same method will end with a timeout error.
I
 can recommend you restore the ODOO database using PSQL queries, which are
 reliable, fast and efficient. Here I can give you simple methods to 
restore the databases using PSQL.
Plain SQL Format
The
 plain text format is useful for very small databases with a minimal 
number of objects but other than that, it should be avoided.
psql -U username -d database -f backupfile.sql
or
psql database < backupfile.sql
Tar Format
Using
 this archive format allows reordering and/or exclusion of database 
objects at the time the database is restored. It is also possible to 
limit which data is reloaded at restore time. we use tar with gzip
pg_restore -d database backupfile.tar -U username
You can add the following parameters
- -c create a new database before restore
- -v verbose mode
- - t particular table only
Compressed Format
This
 is the most flexible format in that it allows the reordering of loading
 data as well as to object definitions. This format is also compressed 
by default.
pg_restore -d database backupfile.sql.gz -U username
or
gunzip -c backupfile.sql.gz | psql -U username -d database
Reference: https://hilarak.medium.com/odoo-database-backup-automatically-restore-using-psql-7aaf5db89f17
Automated Backup Module To Handle Large Database:  https://apps.odoo.com/apps/modules/15.0/auto_backup_odoo/