How to Restore large Backup/Database?

Question

I have been trying to restore big backups but failing at the process, having Internal Server Errors or 404 Error
From what I've read, it's due to a timeout, so the database doesn't finish loading completely.

How can this problem be solved and the process made as simple as possible?
I use Odoo 16 Community

Ray Carnes (ray) · Accepted Answer

Change the value of *limit_time_cpu *and* limit_time_real* in your Odoo configuration file, as discussed in the documentation.
https://www.odoo.com/documentation/17.0/developer/reference/cli.html#cmdoption-odoo-bin-limit-time-cpu [1]
For Odoo.sh, both of these are set to 900 instead of the default 60 and 120.

[1] https://www.odoo.com/documentation/17.0/developer/reference/cli.html#cmdoption-odoo-bin-limit-time-cpu

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Either you can increase the time out limit of odoo/nginx or you can try restoring using the commands from terminal.
For example, if you have dump file, you can restore as follows:  Restore Database From Command Line Using Dump File in Odoo [1]
also with pg_restore command also you can restore the db and manually move the filestore.

Thanks

[1] https://www.youtube.com/watch?v=XrPURF5my9s

Related Posts	Odgovori	Prikazi
HELP- Can I merge missing entries from 2 database backups? databases BACKUP	0 jun. 24	1581
How do I delete a database? databases	3 sep. 25	1855
Backup Error 2022-12-18 15:01:08,474 4921 WARNING ? odoo.service.server: Thread <Thread(odoo.service.http.request.139837619480320, started 139837619480320)> virtual real time limit (156/120s) reached. 202 BACKUP	1 dec. 22	6341
Modules icons are missing after restoring database to another server databases	1 maj 22	5205
make database copy for testing databases	1 apr. 22	7510

This question has been flagged

Enjoying the discussion? Don't just read, join in!