I am having a little trouble managing my databases. I have 2. I am trying to backup the live one but I keep getting and "Access denied" error. I have the current admin password to manage databases. I can create a new database and I can change the password but I cannot backup this database. I know for a fact that the current password to manage databases is NOT the one that was used when this database was created. It was changed from the original one as it was illogical and didn't fit our name conventions. Is it so that databases can only be managed using their original creation passwords and not using the existing database admin password?
If so, how can I find what password was used to create this database? If not, what else could be denying me access?
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.
pg_dump --format=c --no-owner --username=<> --host=<> --port=<> <dbname>
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
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 3/13/14, 8:30 AM|
|Seen: 3517 times|
|Last updated: 3/16/15, 8:10 AM|