I try to figure out how to restore a database from a local installation to a newly configured openerp on another local server.
The origin db is a server on my laptop and the destination is a server on a Raspberry Pi with 512m of memory. Openerp is installed on the Raspberry Pi but anything I try result on 'Impossible to restore database'.
For the restoring process I do the following (v7, Postgresql 9.1.9):
1-I save the database in the administration of the old openerp server--> which give me a ".dump" file.
2-I move the .dump file on the new server and, through the same database administration menu, I restore it with the same name of the blank database.
Help is welcome.
You are probably missing the
pgpass file on the target server.
Inside the home of the system user that run the openerp process, create an hidden file called
Inside this file you have to write something like:
replace myuser and mypassword with the correct postgresql credentials (the ones you can see inside the openerp's server config file).
Set the correct file permission:
chmod 600 .pgpass
Restart OpenERP then try to restore the dump file.
If this doesn't work, try to run OpenERP in foreground (by typing openerp-server --all-the-switch-you-need in the shell). You should notice that OpenERP is asking for the password in the server's shell. If this happens, you need to check pg credentials or auth mechanism in the pg_hba.conf file.
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
|Asked: 5/7/13, 10:51 PM|
|Seen: 3092 times|
|Last updated: 3/16/15, 8:10 AM|