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..
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.
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
|Asked: 10/22/13, 11:36 AM|
|Seen: 647 times|
|Last updated: 3/16/15, 8:10 AM|