Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
5741 Widoki

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

Awatar
Odrzuć
Najlepsza odpowiedź

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.

Awatar
Odrzuć
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 Najlepsza odpowiedź

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

Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
0
lip 25
1503
2
lis 24
6456
2
paź 24
3458
2
sie 24
1996
3
lip 24
8386