Odoo Help


Database specific Master password - does it exist?

on 3/13/14, 8:30 AM 5,163 views


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?


I have done a little more searching and have found that the above does seem to be the case. Thanks Martin Bramwell for this explanation http://help.openerp.com/question/478/what-difference-is-there-between-the-admin-and-master-pass/#487. My Question is now, I do have access to Postgres on this server, where can I see the database password or how can i safely change it? Thanks

on 3/13/14, 8:44 AM

This behaviour can be caused by having odoo 8 installed on one application server and Postgres 9.3 on another, as database server (9.3) and your local pg_dump (9.1) mismatch. Odoo will report a different error, something like you need to set .pgpass ... But, if you run the pg_dump command manually from the application server you will get the correct error. If you look at the db.py code you will see that the server is executing the same command in the background when trying to backup your database. You can ether upgrade pg_dump - this means installing posgres 9.3 on application server (not to use as a database, just the pg_dump) or running the backup command manually on database server.

Martin Pishpecki
on 11/12/14, 3:44 AM

Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 3/16/14, 4:19 AM


  • 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.

Thanks Ray for that very insightful feedback. In fact this is a windows environment and I am attempting to back up the database so that we can migrate to Linux. I think by your comment you seem to have suspected that. Any idea what the environment variables or or other files you speak of may be? Interestingly enough I can log into Postgres and do a manual backup of this database. Would that be sufficient for my migration to Linux or does the backup from the OpenERP interface include any additional data?

on 3/17/14, 2:43 AM

Sorry - I thought I was clear - the backup OpenERP performs is a PostgreSQL backup - I've posted the exact command line syntax for it.

Ray Carnes
on 3/19/14, 1:27 AM

Thanks for your advice Ray. It was really useful to me. How do I give you credit for this?

on 4/3/14, 7:41 AM

Thanks for your advice Ray. It was really useful to me. How do I give you credit for this?

on 4/3/14, 7:46 AM

At the top left corner of the answer I gave, you can click the up arrow to 'vote' for the answer to indicate it helped you. Please do this for any answer on the site you find helpful.

Ray Carnes
on 4/3/14, 2:59 PM

comand line admin_passwd= doesn't seem to exist in Odoo 11

Jonathan Leaders
on 7/18/18, 6:57 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 3/13/14, 8:30 AM
Seen: 5163 times
Last updated: 3/16/15, 8:10 AM