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

Multiple Backup methods and its differences

By
Ram S
on 3/30/13, 5:00 PM 2,683 views

There are multiple ways to backup Database. Namely

  1. Backup from the Web client: Before login go to Database and create Backup Manually
  2. Auto Backup Module: Install Auto Backup Module and Schedule automatically
  3. Run Bash shell Script: Create a shell script and dump PostgresSQL database

My Questions are a. I need a reliable backup. If any issues I can restore and run smoothly. Is their any difference between the above 3. b. For Shell script we need to stop server. What is server runs 24x7 (Example manufacturing environment) and we can't stop the server. What are the best option?

Thank you

3

ton123

--ton123--
1418
| 5 6 9
Lisse, Netherlands
--ton123--
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
ton123
On 3/31/13, 6:18 AM

Three backups you mentioned are not sufficient. They are the easy part ....

You forget a very important thing: YOU NEED ALSO A BACKUP OF YOUR SOFTWARE If something break your software you need to repair or reinstall. If your Hardware fails you need to reinstall your software.

For these things I have:

  1. All installables including modules added scripts, added libraries, etc. Including descriptions of how to install.
  2. An identical hardware / software installation.
  3. An identical virtual machine with the OS and software installation.
  4. You need to test restore of database on a regular basis.
  5. You need to test recovery of OS and Hardware on a regular basis.

Dear Ton,

Pelase let me know, how to accomplished these, Automatically?

GuruDev
on 8/5/13, 5:05 AM

@GuruDev I do not have the answer on this. I do it by hand.

ton123
on 8/6/13, 5:11 PM

My god! Same hardware too? And what happens if we change the server, the O.S. or another upgrade? I see this like a real problem!

Roberto Barreiro
on 10/1/13, 3:30 PM
0
Gustavo
On 3/31/13, 9:47 PM

Chances are... something will go wrong with your server before going wrong with the database. So first I would take a look at backing up and restoring the server, specially the OpenERP server installation. Then I would backup the database with pg_dump, that does a pretty good job in backing up your database.

Now, if you need 24/7 availability, try replicating your database. PostgreSQL does a good job in replicating your DB

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

1 follower(s)

Stats

Asked: 3/30/13, 5:00 PM
Seen: 2683 times
Last updated: 3/16/15, 8:10 AM