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.

Virtualization

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:

https://opensourceconsulting.wordpress.com/2009/09/05/installing-mondorescue/
https://opensourceconsulting.wordpress.com/2009/09/05/linux-p2v-physical-to-virtual-migrations-using-mondorescue-by-hewlett-packard/
http://www.mondorescue.org/
http://mkcdrec.org/
http://www.clonezilla.org/

References:

http://www.postgresql.org/docs/8.3/interactive/backup.html
http://www.openerp.com/forum

Advertisements

September 6, 2009 - Posted by | Backup, ERP |

8 Comments »

  1. I followed those steps written above but i still can’t restore the backup i created

    Comment by Anonymous | February 10, 2012 | Reply

  2. […] to this article I read “A complete OpenERP database can be moved using PostgreSQL’s native backup/restore […]

    Pingback by OpenERP database import/export help (March 6, 2012) « Hubert Jay Lisas | March 6, 2012 | Reply

    • You’re really cool? Listen here, so, oboivusly, I got braces and all this other stuff to make my teeth straighht? I’m sure you don’t have perfect teeth? So fuck off. Are you’re parents paying $6000 for this whole proccess? Oh wait, that’s me. So I’d get off my page and not comment on my stuff if you’re gunna be shitty? If you dontcare, don’t comment on my stuff and watch my videos? Kbye.

      Comment by Mir | May 24, 2012 | Reply

    • The What’s New doc should be out any day now. There were some late edits and sucdehling issues with getting it added to the external web site, but it is my understanding that all of that is nearly resolved.

      Comment by Hiroyuki | January 12, 2013 | Reply

  3. […] Professional, cheap & fast PHP, CGI/Perl script installation & secure file transfer services. Read More… […]

    Pingback by Script Installation Service | March 14, 2012 | Reply

    • I reside in Oklahoma and have rldmoeeed hundreds of foreclosed homes for real estate and mortgage companies. It is illegal in our state to remove appliances or any items for that matter, that originally came with the house. Even if you have replaced it because it wore out, it still cannot be removed. It is theft. However, we have rldmoeeed many houses where appliances, light fixtures, etc, have been removed. I do not know of any mortgage company that has held the previous guarantor liable. I am sure this holds true in all states. Remember, it is THEFT.

      Comment by Nesrin | January 13, 2013 | Reply

  4. Thanks for your sharing. It really helped me to know the details. Someone asked me how to import steel flanges and elbows from China? Why not try Fame Rise Flange Co.,ltd? This is a professional manufacturer for pipe fittings. At the same time, I hope your posts will help more people all over the world.

    Comment by carbon steel flange manufacturer | February 27, 2014 | Reply

  5. Cool blog. Thanks! I know firsthand that running a site like this can often be a thankless effort.

    Comment by website | July 11, 2015 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: