Well, this is my 3rd attempt to run OpenERP it is a brilliant application but we can't decide to move it to production because of backup/restore procedures. It require review by developers it also require more detailed documentation. We have problems event with the: - backup password in simple installation, - restoring openERP on other computer ( windows 7 to windows7 or window 7 to XP
Those (backup/restore) procedures are the most important in live/production environment and should be bulletproof running without any doubts and glitches. So please take deep look ant this problem it is really important and should be review by developers of those modules.
For the backup, see also http://help.openerp.com/question/4728/how-to-setup-a-regular-postgresql-database-backup/, though restores aren't discussed there.