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

Migration possible solutions.

By
umer farooq
on 10/22/13, 11:36 AM 685 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.

kaynis
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

kaynis
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

kaynis
on 10/23/13, 11:38 AM

Yes i will advise you do that

kaynis
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

http://help.openerp.com/question/34542/moving-desired-changes-from-one-database-to-another-avoiding-complete-migration/

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

Brett Lehrer

--Brett Lehrer--
1252
| 5 4 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

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

0 follower(s)

Stats

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