Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
2 Risposte
5885 Visualizzazioni

Hello,

Up to now, we're working with openERP v.5. The server has installed on our ubuntu server station. I succeed in sauvegarding the pgsql database (v8.4 of pgsql) via pgadmin.

I would like now restore this database into my new OPENerp server station (windows7) via the database manager (tool of openerp v7). But when i try to do it, there is an error message saying : its impossible to restore the database.

Acccording to you, is there a way ?

Thank you very much.

Regards.

Avatar
Abbandona
Risposta migliore

There have been a lot of significant changes to how the core system works between v5 and v7, you definitely won't be able to just restore a pg dump file from v5 directly into v7. I believe OpenERP (the company) has the ability to migrate databases between versions, but you'd probably be going from 5 -> 6, then 6 -> 7.

Avatar
Abbandona
Autore

Hello,

Thank you. I succeed in save my database thanks to postgres tool (pg_dump) on my server station (openerp v5 ubuntu). A big file without extension has been generated.

When i try to restore this database on my temporary server (v6/windows 7) via manager database openerp v6 tool, i have again 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/ For restoring, the file must be in For resauration, the file must be in what format?

It's not really that the postgres dump file is bad, it's that some core tables have changed, so newer OpenERP versions are unable to process them.

For example, new to v7 is the lack of res_partner_address - everything is just res_partner (and res_users). The basic structure of the model is different, so a direct import of an old database dump will not work. Even if it did, you'd be missing a bunch of data.

Autore

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.

Autore Risposta migliore

Hello,

Thank you. I succeed in save my database thanks to postgres tool (pg_dump) on my server station (openerp v5 ubuntu). A big file without extension has been generated.

When i try to restore this database on my temporary server (v6/windows 7) via manager database openerp v6 tool, i have again 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/ For restoring, the file must be in For resauration, the file must be in what format?

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
2
mar 15
9943
1
mar 15
6860
1
mar 15
4883
4
lug 24
33917
2
dic 23
2099