Skip to content

Automated database backups from Odoo, both locally and on an FTP server

License

Notifications You must be signed in to change notification settings

Yenthe666/auto_backup

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

1. Prerequisites

This module needs the Python library pysftp, otherwise it cannot be installed and used. Install pysftp through the command sudo pip install pysftp

2. Which version to choose?

Version 16.0 is the latest stable version for this module and is compatible with the latest Odoo version (Odoo 16). The versions 8.0, 9.0, 10.0, 11.0, 12.0 and 13.0 of this module are tested and verified to work for their specific Odoo versions. The master version is the development version and will be for the next Odoo version. The master version is still in testing and contains the newest features, which might still have problems/error.
Tip: At this point the master version is being rewritten to drop the pysftp library need, please don't use this version at this point.
If you need to connect to a remote FTP server on another port than port 22 you should download and install the 9.0, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0, 16.0 or master version. Version 8 does not support another port than 22.

3. Guide / documentation

Need more help with this module or want a guide about how to set this up?

4. Important information

4.1 limit_time_real parameter

When you've configured your Odoo instance to run with workers you should change the default value of limit_time_real (as this defaults to 120). You can configure the value in /etc/odoo/your_odoo.conf to the appropriate number in case of a large database backup. This is required when max_cron_threads > 0 to avoid worker timeout during the backup.

4.2 list_db parameter

The backup module only used to work when list_db was set to True (or was not configured). Since 28/02/2020 ( https://github.com/Yenthe666/auto_backup/commit/c7d0512a0d0b2d42662831008e7a9316b264f23e) you no longer have to have the database manager enabled and the module can also take backups without it being exposed. If you run the backup module before this commit and want to run it without the database manager being exposed you should update the backup module to the latest version first. It is advised to disable the database manager for security purposes. See https://www.odoo.com/documentation/16.0/administration/install/deploy.html#database-manager-security for more information about this subject.

4.3 --load / server_wide_modules parameter

In V12, V13 and V14 Odoo will need the values 'base' and 'web' set if you use the --load (or server_wide_modules) parameter. Without these values set you will get a 404 NOT FOUND from the backup module. For more information see #122

4.4 "No matching record found for external id" error

This happens when you've installed - or tried to install - the back-up module without having the dependency pysftp installed. You might need to restart your Odoo instance or even your whole server for Odoo to recognize the Python package.

4.5 Running on Odoo.sh

If you run on Odoo.sh you should download and install the second module, "auto_backup_sh", along with the "auto_backup" module. This module adds the support for writing backups generated by Odoo SA (on Odoo.sh) to a remote SFTP. As Odoo.sh does not allow triggering backups through command this module reuses the last daily (automated) backup and pushes this backup to a remote location through SFTP: image

5. Bugs or problems

Please post them here under 'Issues' and I will get back to you as soon as I can!

About

Automated database backups from Odoo, both locally and on an FTP server

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Sponsor this project

 

Packages

No packages published