Backup and Restore of complete OpenERP in Linux(Ubuntu)

Backup and Restore of complete OpenERP in Linux(Ubuntu)

This is just some simple tips for moving an OpenERP server instance and Database from a Linux server to another Linux physical server. Normally Debain based Ubuntu is recommend to install OpenERP. Hope this will help at least some beginners. Good luck :) This process is normally done using linux commands as mentioned below.

1) On Source Server
.ssh to existing OpenERP server as the user running OpenERP

• Copy config, binary and init files

demo@openerp:~$ cp /etc/default/demo-server.conf .
demo@openerp:~$ cp /etc/init.d/demo-server .
demo@openerp:~$ cp /usr/bin/demo-server demo-server_bin

• Backup database

demo@openerp:~$ pg_dump -f OpenERP_devel.tar -F tar -O OpenERP_devel

• Create an archive with all these files

demo@openerp:~$ tar -czf oerp_backup.tgz *

• Copy the archive to destination server

demo@openerp:~$ scp oerp_backup.tgz [email protected]:/home/sme_test/

2) On Destination Server

• Create a new user(this must be done before copiying the backup from source server)

root@ubuntu-test:~# adduser sme_test

• Create a postgresql user

root@ubuntu-test:~# su postgres
postgres@ubuntu-test:/root$ /usr/lib/postgresql/9.1/bin/createuser -p 5434 sme_test

• Set password for user

postgres@ubuntu-test:/root$ /usr/lib/postgresql/9.1/bin/psql -p 5434
postgres=# alter user sme_test with password 'smellycat';

• Switch to new user

root@ubuntu-test:/home/sme_test# su sme_test

• Change to home directory

sme_test@ubuntu-test:~$ cd

• Extract the archive

sme_test@ubuntu-test:~$ tar -zxf oerp_backup.tgz

• Edit config, init and binary files to cope with new system and database user

• Switch back to root user and create log file

sme_test@ubuntu-test:~$ exit
exit
root@ubuntu-test:/home/sme_test# touch /var/log/sme_test-server.log
root@ubuntu-test:/home/sme_test# chmod 777 /var/log/sme_test-server.log

• Copy the edited files to appropriate locations

root@ubuntu-test:/home/sme_test# cp demo-server /etc/init.d/sme_test-server
root@ubuntu-test:/home/sme_test# cp demo-server.conf /etc/default/sme_test-server.conf
root@ubuntu-test:/home/sme_test# cp demo-server_bin /usr/bin/sme_test-server

• Switch user to new OpenERP user, create database and restore database

root@ubuntu-test:/home/sme_test# su sme_test
sme_test@ubuntu-test:~$ /usr/lib/postgresql/9.1/bin/createdb -p 5434 OpenERP_restore
sme_test@ubuntu-test:~$ /usr/lib/postgresql/9.1/bin/pg_restore -p 5434 -d OpenERP_restore -O Dilavie_devel.tar

sme_test@ubuntu-test:~$ exit

• Start new OpenERP Server

root@ubuntu-test:/home/sme_test# /etc/init.d/sme_test-server start

• Connect and test