Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
1 Ответить
302 Представления

Hi guys,


I'm having trouble backing up one of my clients' databases.

The client's database is over 10GB with the filestores.

When I tried to download it through the web interface, it didn't download everything because the file was incomplete each time.

I installed a backup module in Odoo to manage this, but the backup is never complete.

My client has an Odoo.sh license, so I have to back up my server's database and restore it on odoo.sh, but now the backup isn't working.

What should I do?



Аватар
Отменить
Лучший ответ

Hi,

For large databases (10GB+), downloading through the web UI often fails because the HTTP request times out or the archive is too heavy. Since your client is on Odoo.sh, you have safer options:

  1. Use Odoo.sh backups → in the Odoo.sh dashboard, each branch has automatic daily backups. You can download them directly from there without going through the web interface.
  2. Use pg_dump → if you still need to back it up manually from the server, connect via SSH and run:

    pg_dump db_name -Fc -U odoo > db_name.dump

    And copy the filestore separately with:

    scp -r /home/odoo/.local/share/Odoo/filestore/db_name user@yourmachine:/backup/

    Then restore on Odoo.sh with the .dump file and filestore.
  3. Avoid custom backup modules — they often fail with large filestores. Stick to Odoo.sh built-in backups or native PostgreSQL tools.

So the best way is: download a recent backup directly from Odoo.sh dashboard, or export with pg_dump if you need more control.

Hope this helps.

Аватар
Отменить