Odoo Help


6 Answers

Med Said BARA Algeria

--Med Said BARA--

| 6 5 10
Guelma, Algeria
--Med Said BARA--

Med Said BARA Algeria
7/29/18, 9:52 AM

Use PgAdmin (or any other tool or editor) to edit your pg_hba.conf by following the instructions provided in this page

Carlos A García Cuba
7/5/19, 6:25 PM

The solution in your link works great, thanks!

Med Said BARA Algeria
7/9/19, 7:41 PM

Good luck; Thanks.

taabouri naima Tunisia
7/4/14, 8:22 AM

hi plz i have the some problem; and i can't resolve it plz if you have resolved it tell me how ???

medhabib Malta
8/19/14, 9:52 AM

make sure that you can connect in with login user and passwd in pgadmin if the autentification  is good then restart your postgres server and it work fine 

Carlos A García Cuba
7/5/19, 6:24 PM

Steps suggested to get rid of this error:

1. Stop your OpenERP server.

2. Stop your PostgreSQL server : $ sudo /etc/init.d/postgresql stop

3. Edit your PostgreSQL configuration file pg_hb.conf using nano or gedit editor :
$ sudo gedit /etc/postgresql/9.X/main/pg_hba.conf

4. Now, In the pg_hba.conf file search for the following lines:
# "local" is for Unix domain socket connections only
local         all        all        peer

Here, in above line type of connection used is “peer”, change it to a “trust” i.e.
local         all        all        trust

Now, Save and close the file.
5. After making the above changes to the configuration filepg_hba.conf, Reload and start the PostgreSQL server :
$ sudo /etc/init.d/postgresql restart

This approach works too in Odoo 11 and Ubuntu 16.04 and should resolve the error.

Ask a Question
Keep Informed
2 follower(s)
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