Odoo Help


Can't connect to postgres with user

Mike Greenish
on 9/6/16, 5:43 PM 2,397 views

I am installing odoo 9.  I have followed the instructions and installed the server without issue.  Now I can't seem to get the database connection going. For the database, I installed postgres and then did the following:

1. create user

> createuser --createdb --username postgres -h --no-createrole --no-superuser --pwprompt odoo9

2. update pg_hba.conf

local all odoo9 md5

host all all md5

I can connect to the database on the command line 

> psql -U odoo9 -d db_addhaptics_odoo9

Password for user odoo9:

psql (9.3.11)

Type "help" for help.


I have updated the odoo config file to match the username and password.  But when I try to launch the site, I get the following in my odoo log:

2016-09-06 21:42:02,893 19282 INFO ? openerp.addons.bus.models.bus: Bus.loop listen imbus on db postgres

2016-09-06 21:42:02,897 19282 INFO ? openerp.sql_db: Connection to the database failed

2016-09-06 21:42:02,898 19282 ERROR ? openerp.addons.bus.models.bus: Bus.loop error, sleep and retry

Traceback (most recent call last):

File "/opt/odoo9/addons/bus/models/bus.py", line 168, in run


File "/opt/odoo9/addons/bus/models/bus.py", line 146, in loop

with openerp.sql_db.db_connect('postgres').cursor() as cr:

File "/opt/odoo9/openerp/sql_db.py", line 630, in cursor

return Cursor(self.__pool, self.dbname, self.dsn, serialized=serialized)

File "/opt/odoo9/openerp/sql_db.py", line 164, in __init__

self._cnx = pool.borrow(dsn)

File "/opt/odoo9/openerp/sql_db.py", line 513, in _locked

return fun(self, *args, **kwargs)

File "/opt/odoo9/openerp/sql_db.py", line 581, in borrow


File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect

connection_factory=connection_factory, async=async)

OperationalError: FATAL: password authentication failed for user "odoo9"

What am I doing wrong?

Kinner Vachhani
On 9/7/16, 7:04 AM

Hi Mike,

Change the db_host in config to and see if solves it.

Mike Greenish
On 9/7/16, 4:57 PM

Hi Kinner,

Changing the db_host (and adding a corresponding host line in my pg_hba.conf) did the trick!

Thanks for the help!!!



Ermin Trevisan

--Ermin Trevisan--
| 6 5 7
Walchwil, Switzerland
--Ermin Trevisan--

Ermin Trevisan
On 9/7/16, 3:05 AM

As per Odoo's installation instruction the user must be a superuser:


and the username to connect as should be Odoo9 and not postgres.

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: 9/6/16, 5:43 PM
Seen: 2397 times
Last updated: 9/7/16, 4:57 PM