Hello Tuni ERP, 

This issue can sometimes occur if the database backup is large or if the web interface reaches a timeout during the restore process.

If you're encountering a server time out error, you can adjust the time limits in your Odoo configuration file (odoo.conf) by adding the following parameters: 

    limit_time_cpu = 1200

    limit_time_real = 1200

These settings increase the allowed processing time and can help with large database restores.

If you're using a Linux-based system like Ubuntu, it's generally more reliable to restore the database via the terminal instead of the web interface.

 Here’s a step-by-step guide:

1. Unzip your .zip backup file — it typically contains a .sql dump file inside.

2. Create a New PostgreSQL Database

    - Open a terminal and run the following command to create a new empty database (replace your_database_name with your preferred name):

createdb your_database_name

 3. Restore the SQL Dump

   - Use the following command to restore the .sql file into the new database:

psql your_database_name < /full/path/to/your_dump_file.sql

Make sure to replace the path with the actual location of your dump file. 

Once completed, your database should be restored and accessible via your Odoo instance.

Feel free to reach out if you have any questions or run into issues - happy to help !! 

Thanks & Regards,

Email:  odoo@aktivsoftware.com           

Skype: kalpeshmaheshwari

From the logs, it is evident that when you try to restore a db, the thread reaches a time limit and is killed. In order to fix this try setting the limit_time_cpu and limit_time_real parameters in your odoo-sever.conf file. You will find a lot of examples of these in other posts. Let us know if it works. Thank you