Odoo Help

Welcome!

This community 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.

0

Restore a postgres db (openerpv5) : error message

By
Sales
on 5/27/13, 8:08 AM 1,139 views

Hello.

I just installed a temporary openerp v5 all in one on my windows station. But it's always the same thing. I can't load 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.

Could you throw light for me please?

Regards.

try running a pg_restore or restore the database with psql, that you will give you more information on what might be going wrong

Gustavo
on 5/27/13, 11:21 AM

Hello. When i try to restore the db with pg_restore : "the file does not seem to be a valid archive". For information, when i have installed the openerp all in one on my windows station, the database has not been installed because the installer detected another postgresql server (9.1) for postgis already installed on my windows station. So i make a restoration test with postresqk tools 9.1. And my dump file has been save from my linux openerpv.5 postgresql 8.6. Could you throw light for me?

Latitude Geosystems SAS, Sales
on 5/27/13, 11:52 AM
0
Sales
On 5/27/13, 12:01 PM

Hello. When i try to restore the db with pg_restore : "the file does not seem to be a valid archive". For information, when i have installed the openerp all in one on my windows station, the database has not been installed because the installer detected another postgresql server (9.1) for postgis already installed on my windows station. So i make a restoration test with postresqk tools 9.1. And my dump file has been save from my linux openerpv.5 postgresql 8.6. Could you throw light for me?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 5/27/13, 8:08 AM
Seen: 1139 times
Last updated: 3/16/15, 8:10 AM