This question has been flagged
3 Replies
8719 Views

Hello everyone  please i want to know if there a method to make a full backup of odoo 9 on development server ubuntu v 15.04

thanks

Avatar
Discard

i want to make a full backup including ( Python, QWeb, JavaScript et XML, ) 

Are you looking for a full backup of the server or backups of the different tenants (databases including their filestores)?

Best Answer

in case you are talking about the database, which is what should really matter (else do a normal system backup or use a dockerfile...), you have several choices:

  1. use the integrated database backup (under "manage databases" on the login screen)

  2. use the promising (but sadly not working for me) auto_backup module from https://www.odoo.com/apps/modules/9.0/auto_backup/

  3. use a custom script (ideally triggered from cron) that backs up the database, like:

    /usr/bin/pg_dump -U <dbuser> --host localhost --format custom --blobs <dbname> > $filename

    bzip2 $filename
    for this to work, you'll need a .pgpass file in the home directory of the user doing the backup (in case of cron, it should be in /root), with the following content:

    localhost:5432:<dbname>:<dbuser>:<dbpass>

Avatar
Discard

Only (1) will backup the filestore (a set of files stored outside the database, including website and attachments) necessary for everything to work properly. The filestore can be found in the home folder of the user (or service) who is running the Odoo server at .local/share/odoo

Ray: auto_backup does also backup the filestore.

Best Answer

How to backup odoo database automatically

Available Backup DB/Filestore Modes:

  • Local
  • Remote Server
  • Google Drive
  • Dropbox

Module For backup ODOO databases and automating the backup process of ODOO.

  • Multiple Backup Modes
  • Filestore Backup
  • Backup ODOO Databases in specified path
  • Detailed Message Log
  • Backup Status Information and History
  • User can select the format to dump, either custom archive, plain text SQL or tar archive
  • Archive Backup Process
  • Repeat Missed Backup Process

Features

  • Dump ODOO Database in specified format
  • Output a custom archive suitable for input into pg_restore. This is the most flexible format in that it allows the reordering of loading data as well as to object definitions. This format is also compressed by default. Here we user gzip ie, test.gz, We also recommend you to select Custom, because Using the custom format you can restore single objects from a backup.
  • Output a plain-text SQL script file (the default). The plain text format is useful for very small databases with a minimal number of objects but other than that, it should be avoided.
  • Output a tar archive suitable for input into pg_restore. Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. It is also possible to limit which data is reloaded at restore time. we use tar with gzip
  • Backup Filestore
  • Multiple backup modes at sametime

Get Module From Here


Video Demonstration


Avatar
Discard
Best Answer

how to restore a backup stored in the local server?

Avatar
Discard