Well,

OpenERP is a brilliant application, it really is, but, windows version is not ready for production. this is my 3rd attempt to evaluation for live implementation. The weakest pint in OpenERP but, the most importation for production is solid bullet proved backup/restore functionality.

1. Installation CRM and a few modules, import/export data is going well
2. For a some time testing/evaluation including backup/restore is going well
3. Restoring on other computers has number of problem module update doesn't help ...
4. SUDDENLY on original instillation backup function return "database Backup Access Denied"

Looks like problem with master password in section of managing databases BUT PASSWORD IS RIGHT.

Other function such as 'create', 'drop' and so on are just fine with provided "admin" password even 'backup' function was working fine too until some unexpected moment where nothing special has been done to o applications but, 'backup' function start SUDDENLY responding with "Access Denied" Other functions drop, create, ... work OK but 'backup' NOT.

Conclusion: The most important function from production point of view should be deeply reviewed and make a bullet proved in any configuration and cross platform environment to have openERP ready for production environment.

Well, YES we can hack and play with cases like this but only in testing and private environment for live environment it is work which has to be done.

Sasha

Check pg_path in your openerp-server.conf, it solved my problem

make sure all your tables in the database you're trying to backup are owned by the user odoo erp uses, i.e. openpg, odoo, or whatever was set during installation of the erp system

You have problem accessing your database server. Looks like your credentials are not authorized. Try running psql or createdb from the command line to confirm your authorization problem

There are different use/password combinations related to openERP.

You have password admin, which is the default password for managing the openERP databases, like drop and restore.

When you create a new database, the username is admin, and the password is what you have to type twice before the process continues.

And you have the openERP user / password, which is needed to connect openERP to the database. This password might have been made during the installation of openERP (value depends on which OS used and the steps you have taken).

If you do not know the password for creating/dropping/backing up the database, you can find it at: <have to="" get="" my="" papers......&gt;="" <="" p="">