Odoo Help


Migration possible solutions.

umer farooq
on 10/22/13, 11:36 AM 999 views

Hello, I have implemented openERP7 in 2 servers 1 for testing(QC) and 2nd for production(PROD). Now i need to move database of QC to PROD ,One solution would be using pgadmin and make backup of desired database and in prod restore it and also copy addons folder of qc and replace it with prod addons folder it worked fine.But the other solution which is to backup database through openerp7 GUI in manage databse section it gives an error "ACCESS DENIED" in QC server but it's working fine in PROD server.Like i can backup and restore database thorugh GUI in prod but why it's not working in QC server. Is this is the server problem or something else please help me with this..

try using another browser that sometimes helps.

on 10/22/13, 11:54 AM

Used IE,Fire Fox and Google chrome.still it's same.

umer farooq
on 10/22/13, 12:36 PM

Try this which once worked for me. Log everyone out of the database and restart the database. Reload base module and open with Safari then try backing up the database again and restore with Safari. That has worked for me once. I think It is not really a problem just a bug that comes up now and then in the system

on 10/23/13, 5:32 AM

Tried it too not working for me :( should i Go for Pgadmin solution backup and restore it from there??

umer farooq
on 10/23/13, 9:04 AM

Yes i would say that you do that

on 10/23/13, 11:38 AM

Yes i will advise you do that

on 10/23/13, 11:41 AM

Thaks Kaynis I have another Problem I think you can help me please have a look at this question I will be very grateful to you :)

umer farooq
on 10/23/13, 11:42 AM


umer farooq
on 10/23/13, 11:42 AM

Brett Lehrer

--Brett Lehrer--

| 5 5 8
Milwaukee, United States
--Brett Lehrer--
Director of IT and open source enthusiast.
Brett Lehrer
On 10/22/13, 12:53 PM

I've noticed the same problem. What I do is just shut down OpenERP on that database so no db users are connected (close down any logged in pgAdmin windows too), then use pg_dump.

pg_dump -C my_database | gzip > my_database.sql.gz

After migrating that file, extract and install in the new database:

gunzip my_database.sql.gz
psql -U openerp -d postgres -f my_database.sql

This creates the new database my_database (due to the -C flag in pg_dump), so if it already exists and you want to replace it, make sure to drop the existing db on the target system first.

That's what i am doing already through pg admin.

umer farooq
on 10/22/13, 1:23 PM

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 10/22/13, 11:36 AM
Seen: 999 times
Last updated: 3/16/15, 8:10 AM