OpenERP Appliance

Collaboration Works

HOWTO Backup OpenERP

For saving OpenERP you need to backup the Database with your data.

From the GTK openerp-client menu

  • File-> Databases->Backup Database

Then you can restore it after saving from the same menu:

  • File-> Databases->Restore Database

From the OpenERP Web login screen

  • Databases -> Backup / Restore

pgAdmin III

A complete OpenERP database can be moved using PostgreSQL’s native backup/restore mechanism. Apart from the command line, the easy and straightforward way is to use pgadmin3 (GUI admin tool). Run pgadmin3, then connect to the database server, right click on the database name and select Backup from the contextual menu. I recommend to use COMPRESS mode (native and efficient) to save the backup. Still using pgadmin3, connect on the destination server, create a new database, right click on its name and select Restore.


Consider virtualizing your OpenERP installation. This would allow you to redeploy OpenERP by cloning your OpenERP’s virtual machine.

One great virtualization solution and probably the easiest way to set up a virtual machine in Linux is KVM, already available in Fedora 11 and the new Red Hat Enterprise Linux 5.4. KVM is intregated in the Linux kernel and virtual machines can be easily deployed with virt-manager and Virtual Network Editor (GUI tools). CentOS 5.4 & ScientificLinux 5.4 (RHEL clones) will be available in 2-4 weeks.

System Backup and Bare-Metal Restore on Linux platforms

You can also backup your OpenERP Software for bare-metal recovery:



September 6, 2009 Posted by | Backup, ERP | | 8 Comments

Installing MondoRescue. System Backup for bare-metal recovery of Linux

Mondo is a GPL disaster recovery solution to create backup media (CD, DVD, tape, network images) that can be used to redeploy the damaged system, as well as deploy similar or less similar systems. In the event of catastrophic data loss, you will be able to restore all of your data [or as much as you want], from bare metal if necessary. Mondo is in use by Lockheed-Martin, Nortel Networks, Siemens, HP, IBM, NASA’s JPL, the US Dept of Agriculture, dozens of smaller companies, and tens of thousands of users. The backup media is created while the system is up and running. Those coming from an HP-UX background may liken MondoRescue to Ignite-UX.

Installing MondoRescue on Ubuntu

$ sudo apt-get install mondo

Installed version: 2.2.7-2

Installing MondoRescue on Red Hat Enterprise Linux / CentOS / ScientificLinux

Mondo is available from the RPMForge repository.

# yum install mondo

Installed version: 2.2.4

Installing the latest version of MondoRescue is highly recommended. The current release of Mondo is 2.2.8-1, and can be obtained from the MondoRescue repository

Install the following binary packages suited for your distribution if they are available at the MondoRescue repository (i.e. afio and buffer are sometimes unavailable meaning that they are not required):

  • afio
  • buffer
  • mindi
  • mindi-busybox
  • mondo
  • mondo-doc

The previous binary packages can be installed from the command line with these commands:

  • RPM based Linux distributions (Red Hat, Fedora, SuSE, etc): rpm -ivh *.rpm (as root)
  • DEB based Linux distributions (Debian, Ubuntu, etc): dpkg -i *.deb (run as root or “sudo dpkg -i *.deb” on Ubuntu)

Most of the time, you’ll be able to download directly the packages suited for your distribution. Currently provides packages for :

Older packages are also on the ftp site to help for some old fashion distros/versions.

Running mondoarchive and mondorestore

Run mondoarchive as root or with “sudo” on Ubuntu. The following screenshots show how to create an ISO based backup media:

Now we have an ISO image that can be burnt into a DVD. Our system can be easily redeployed or restored by booting from this DVD. To format and restore all files automatically type “nuke” <ENTER> at the boot prompt (bare-metal recovery).

To restore you also have mondorestore.

NOTE – For migrations in a production environment it’s good practice to use a temporary IP address on the machine to be backed up. This will mean users and services can’t connect to the server during the backup.
NOTE – As the archival is done live on the system, you may want to stop all processes maintaining coherent information, such as RDBMS systems for which the operation could cause a synchronisation data issue.

Video: Bare-metal recovery from CD


Mondo Rescue and Ample

MondoRescue HOWTO
HOWTO run mondo interactively using cron
Bare-metal restore
Linux P2V (physical to virtual) migrations using mondorescue by Hewlett Packard

September 5, 2009 Posted by | System Backup, Video | | 13 Comments

Linux P2V (physical to virtual) migrations using MondoRescue. By Hewlett Packard

View this document on Scribd

This document is available at with the source (.odt) in the same directory.

September 5, 2009 Posted by | Docs, P2V, System Backup | | 12 Comments

How to upgrade OpenERP on Ubuntu Linux

Here are my steps to upgrade OpenERP from 5.0.2 release to 5.0.3 on Ubuntu Linux. Please note this procedure only applies when OpenERP 5.0.2 was previously installed from source code (.tar.gz files). This upgrade is easy because both releases share the same Python libraries. This procedure is expected to work with the next OpenERP releases.

TIP: Copy and paste the following lines on a linux terminal

cd /opt
sudo apt-get install wget -y
sudo wget
sudo wget
sudo wget
sudo tar xvzf openerp-server-5.0.3.tar.gz
sudo tar xvzf openerp-client-5.0.3.tar.gz
sudo tar xvzf openerp-web-5.0.3.tar.gz
cd /opt/openerp-server-5.0.3
sudo python install
cd /opt/openerp-client-5.0.3
sudo python install
cd /opt/openerp-web-5.0.3
sudo python install

August 26, 2009 Posted by | Backup, ERP, Linux, Procedure, Ubuntu Desktop, Ubuntu Server Canonical | , | 10 Comments