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

المنشورات ذات الصلة	الردود	أدوات العرض
HELP- Can I merge missing entries from 2 database backups? databases BACKUP	0 يونيو 24	804
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 ديسمبر 22	5426
Modules icons are missing after restoring database to another server databases	1 مايو 22	3988
make database copy for testing databases	1 أبريل 22	5563
Database reinstallation databases	2 نوفمبر 20	4127

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!