Hello,
I succeed in restoring a database into my postgresql server (v9.2) for openerp thanks to psql tools. The db is indeed visible via pgadmin. But via the administration db tools (openerp7), this db is not visible.
Why this db seems not to be recognized via the webinterface?
Thanks.
How did you make the backup in the first place? If you used some kind f command line, you need to use that to restore.
Thank you Patrick. Yes indeed i did the BU thanks to pg_dump on my ubuntu/openERPv5/postgresql8.3 and now i 'd like restore it on my new windows/openerp7/postgresql9.2
I'm not sure that backup is compatible with your current structure. Either way, you should try restoring your database through pgAdmin III rather than through the OpenERP UI.
In case you have pgAdmin III on your ubuntu distro, I'd advise making a new backup using pgAdmin there and then restoring it under your windows OS. When backing up choose: Format=custom, Encoding=UTF8 & rolename=openpg.
Laurens might have given the best answer, In your inital question there was no mention of trying to do an upgrade from V5 to V7. You might have to do it in 2 steps, first to V6, than to V7. But that is another question I think... :)