Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

how to configure Odoo 8.0 for automatic backup including filestore

By
Garth Mathers
on 12/5/14, 12:40 PM 2,781 views

I need some advice on how to configure Odoo 8.0 for automatic backup.

From what I’m reading online, it appears that this version of Odoo now needs both a pg_dump backup and a filestore backup (and the Manage Databases option in the log in dialog automatically puts both in a .dump file).

How can I automate this and schedule it to happen once or twice a day? The script examples I’m seeing online appear to only deal with the pg_dump part of the backup – not the filestore portion.

Another possibility I have noticed would be to implement this change http://anybox.fr/blog/postgresql-large-object-storage-for-odoo so that the large objects just get stored in the pg database and I can then just use the pg_dump scripts method without worrying about a separate filestore.

Thank you for your answer. Sorry i don't have enough karma yet to mark it as answered.....

Garth Mathers
on 12/10/14, 9:49 PM

If you are un Ubuntu, I can put all my script here for you. Just ask it. Have a good day.

Pascal Tremblay
on 12/11/14, 4:58 AM

If you are on Ubuntu, I can put all my script here for you. Just ask it. Have a good day.

Pascal Tremblay
on 12/11/14, 4:58 AM

Please do, Pascal - i would really appreciate it. I'm surprise that Odoo doesn't have automatic backup builtin consider how important it is....

Garth Mathers
on 12/11/14, 8:31 AM

I will publish my scripts in an other post. Did you try http://24.226.196.31:8069/web/database/manager ??? You can backup there. But it is not automatic.

Pascal Tremblay
on 12/11/14, 8:58 AM

https://www.odoo.com/forum/help-1/question/how-to-script-database-backup-on-ubuntu-70165

Pascal Tremblay
on 12/11/14, 9:03 AM
0
George Mengelberg
On 12/5/14, 11:48 PM

You can use Barman (http://www.pgbarman.org/) to provide continuous backup with PITR capability.  For filestore you could use rsync.

I would not recommed putting binary objects in the database.  It makes backups much larger, recover to take longer, and negatively affect DB performance.

Hi George, i am new to servers in general and how much more so to odoo. when you say filestore use rsync, how do i do that? where are the files located? where is the database located? I have a freenas on my network that i want to use to backup the databse and filestore!

Benjamin
on 5/12/16, 1:47 PM

Hi Benjamin, Check your configuration file (https://goo.gl/s2iBvS) to see if the 'data_dir' directive is set. If so, this will be the root of where your files are stored. Otherwise, on linux it will be in your home directory under '.local'. There is a directory for each database and within each will be a 'filestore' directory The attachments are stored there. For the database, you can run 'pg_config' or 'pg_conftool show all' to get a good picture of your PostgreSQL installation. Here are some links for you: Barman: http://www.pgbarman.org/ Duply (uses rsync): https://goo.gl/gO3VLi Filestore info: https://goo.gl/2ydDm4

George Mengelberg
on 5/12/16, 7:56 PM
0
Benjamin
On 5/16/16, 2:10 PM

thank you for your help on this.

can i please ask you for a favor, i now have my folder with the filestores in them.  what is the rsync code to rsync them to a local freenas on my network at 192.168.1.17/mnt/freenas/odoo.

also is there a way to use barman on freenas?  or whats the test way to backup postgres sql to freenas on my network?

also i need some custom work done in odoo, do you offer such services?  if yes can you please give me your email so we can chat more there.

  thank you again for everything.    

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

3 follower(s)

Stats

Asked: 12/5/14, 12:40 PM
Seen: 2781 times
Last updated: 5/16/16, 2:10 PM