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.
An interesting project. Not sure I'd be impressed with the speed though! Do you have further details about how you are doing the dump from the original database and how you are attempting to do the restore. Looking through the openerp and postgres logs would be a good place to start to further expand on what the actual error is.
The speed with the Pi is actually a lot faster than I thought, response is around 2-3 seconds when charging new menus and almost inmediate when in the same menu. There is still no datas though...