Hi,

There's obviously a bug with OpenERP's backup/restore function. However, it's 
possible to move a complete OpenERP database using PostgreSQL's native 
backup/restore mechanism. Apart from the command line, the easy and 
straightforward way is to use pgAdmin III (free download from PostgreSQL's Web 
site).

Download and install pgAdmin, then connect to the database server, right click 
on the database name and select Backup from the contextual menu. I recommend to 
use COMPRESS mode (native and efficient) to save the backup. Still using 
pgAdmin, connect on the destination server, create a new database, right click 
on its name and select Restore.

This procedure seems to work in most cases, although I do myself experience 
errors with my new server when opening the Partner form. But, since everything 
else is working properly, and according to the error message I get, I suppose 
the problem might not be related to the database itself. I will post my problem 
in another thread but I will keep monitoring this one in case someone has a 
question about backing up and restoring PostgreSQL databases.




-------------------- m2f --------------------

--
http://www.openobject.com/forum/viewtopic.php?p=33522#33522

-------------------- m2f --------------------


_______________________________________________
Tinyerp-users mailing list
http://tiny.be/mailman/listinfo/tinyerp-users

Reply via email to