Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
5729 Zobrazení

Hi, 

I am trying to restore a database in openerp 7.0 and postgres version 9.2 but Odoo show an error "Could not restore the database". The backup database is in OpenERP 7.0 windows environment and this database I want to restore it in OpenEPR linux ubuntu 12.04 installation but gives the above error. When i try to restore this database in another windows installation of OpenEPR everything works fine. 

Can anybody help me? 

Regards

Avatar
Zrušit
Nejlepší odpověď

First, make sure you are using the exact same postgres versions. If you are sure that is the case, then make sure to use pg_dump on the commandline with the flag --format="c". Then restore using postgres pg_restore.

Avatar
Zrušit
Autor

Thanks Ludo I checked the postgres version both on windows and ubuntu and there are diferent, 9.2.2 on win and 9.2.6 in linux. What is recomended to do? to donwgrade postgres on linux to 9.2.2? Regards

Using the format=c when exporting should make the export/dump of your database not afflicted by any version difference, so you do not need to down/up-grade any of your postgres versions. More documentation, see: http://www.postgresql.org/docs/9.2/static/app-pgdump.html

Autor Nejlepší odpověď

Thanks Ludo

I checked the postgres version both on windows and ubuntu and there are diferent, 9.2.2 on win and 9.2.6 in linux. What is recomended to do? to donwgrade postgres on linux to 9.2.2?

Regards

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
0
čvc 25
1503
2
lis 24
6452
2
říj 24
3456
2
srp 24
1993
3
čvc 24
8385