No.

• It is not the case that there is a 'database' password.

• It is not the case that a database somehow has knowledge of the password used to create it or required to back it up.

There are just USER passwords, or SYSTEM passwords.

Generic, unaltered PostgreSQL function calls are made for all database operations, including backup and restore.

Backup:

pg_dump --format=c --no-owner --username=<> --host=<> --port=<> <dbname>

Restore:

pg_restore --no-owner --dbname=<>

Note: on Windows, credentials are supplied via environment variables and/or additional files.

Verify this for yourself in the code at

http://bazaar.launchpad.net/~openerp/openobject-server/7.0/view/head:/openerp/service/web_services.py#L265

There is one MASTER SYSTEM password, set in the OpenERP configuration file (something like /etc/openerp-server.conf but can be changed) or on the command line via admin_passwd=. It can also be changed via the UI, and in this case is stored in a resource file called .openerp_serverrc in the home directory of the user running the service.

Other passwords OpenERP uses:

1) SYSTEM: db_password - if a specific password is setup for OpenERP to log into PostgreSQL for administrative purposes.

2) USER: database specific passwords, created within each database.

TIP - If you can create databases but not back them up, try killing any idle PostgreSQL connections.