콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
2 답글
5720 화면

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

아바타
취소
베스트 답변

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.

아바타
취소
작성자

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

작성자 베스트 답변

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

아바타
취소
관련 게시물 답글 화면 활동
0
7월 25
1503
2
11월 24
6452
2
10월 24
3456
2
8월 24
1993
3
7월 24
8385