Odoo Help

0

Restore a postgres db from openerp v5(ubuntu) to v6(windows7) ?

By
Sales
on 5/24/13, 8:50 AM 2,225 views

Hello,

Up to now, we worked with openerp v5 (server installed on ubuntu). I succeed in save my database thanks to postgres tool (pg_dump). A big file without extension has been generated.

When i try to restore this database on my new server (v6/windows 7) via manager database openerp v6 tool, i have a error message saying "impossible to restore the database".

1/When i save a db from my openerp v5 (ubuntu), am i obliged to use a the openERPmanagerDB or i can also use postgresql tools like pgadmin or pg_dump?

2/According to you, why i receive this error message? For restoring, the file must be in what format? What file formats are supported?

In advance, thank you to throw light for me.

between V5 and V6 sn't the same structure of database...

Olivier Lilian
on 5/24/13, 10:54 AM

Hello. Ok. I just installed a temporary openerp v5 all in one on my windows station. But it's always the same thing. I can't browse a dump file saved from my old linux ubuntu server (openerp v5 also) thanks to postgrestools(pg_dump). Why? these are the same versions of the software. I have this error message saying : the db can't be restored.

Latitude Geosystems SAS, Sales
on 5/27/13, 8:00 AM
0
Sales
On 5/24/13, 11:33 AM

Hello. Thank you for your message. I'm a little suprised because i thought it's possible to restore a v5 db into a v6.COuld you tell me how to migrate with Python scrips please so?

In advance thank you.

0
Gustavo
On 5/24/13, 11:15 AM

You can not restore a v5 database in a v6 database because the table structure changes from version to version. I am afraid you will need to migrate with Python scripts

Hello. Thank you for your message. I'm a little suprised because i thought it's possible to restore a v5 db into a v6.COuld you tell me how to migrate with Python scrips please so?

In advance thank you.

Latitude Geosystems SAS, Sales
on 5/24/13, 11:33 AM

Hello. Ok. I just installed a temporary openerp v5 all in one on my windows station. But it's always the same thing. I can't browse a dump file saved from my old linux ubuntu server (openerp v5 also) thanks to postgrestools(pg_dump). Why? these are the same versions of the software. I have this error message saying : the db can't be restored.

Latitude Geosystems SAS, Sales
on 5/27/13, 8:00 AM

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.

Register

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)

Stats

Asked: 5/24/13, 8:50 AM
Seen: 2225 times
Last updated: 3/16/15, 8:10 AM