Odoo Help


How can I know the password of the openerp Postgresql user ? v7

Yassine TEIMI
on 1/1/15, 2:35 PM 789 views

On postgresql, there is the openerp user, it gives the possiblity to interact with postgres via user interface. I want to get the password.

On shell, I went to psql template1, and I performed :

select passwd from pg_user where usename = 'openerp'; 

but the password is crypted, is there any way to know the uncrypted password ?




| 5 4 6
Zagreb | Karlovac, Croatia

there is only 10 kind of people the ones that understand binary ... and others

On 1/2/15, 2:42 AM

If you can start your openerp server then password is in config file,

Look at /etc/openerp-server.conf (or some custom location) open the file and read the ass (db_password = some_pass)

Otherwise, if you can't run openerp server, then you will first need to change the password, 
(and write new one in config file ,restart server)
if you need to change pass:
alter role openerp with password 'your_new_password';

hope it helps

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

1 follower(s)


Asked: 1/1/15, 2:35 PM
Seen: 789 times
Last updated: 3/16/15, 8:10 AM