Odoo Help


Postgres server password inside openerp-server.conf file!!

Anas Taji
on 2/17/14, 10:00 PM 17,459 views

I can read the Postgres server username and password inside the openerp-server.conf file, how to hide/encrypt the Postgres password?

Removing/changing the values will prevent openerp server from connecting to postgresql database server.

André Schenkels
On 2/18/14, 5:49 PM

You should change your PostgreSQL Server configuration.

If you run the OpenERP server with a openerp user make sure the pg_hba.conf file has a setting telling the postgresql server to use peer or ident authentication and not MD5.

If this is the case you are able to just put the db_user=openerp in your OpenERP server config file and it will no longer be needed to put the password in the config file.

André Schenkels

In my openerp-server.conf, there is only written admin_passwd in plain text, but not the password for postgres database user, although my psql authentication mode in pg_hba.conf file is set to MD5...

on 8/13/14, 9:52 AM

You can't BUT you can make it secure.

  1. Use an user just for openerp not a general admin of postgresql
  2. Adjust the permisions of the file:

    chmod 600 openerp-server.conf

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

3 follower(s)


Asked: 2/17/14, 10:00 PM
Seen: 17459 times
Last updated: 3/16/15, 8:10 AM