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

Question

I faced following error please give resolution..
OpenERP Server Error
Client Traceback (most recent call last):
File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\http.py", line 203, in dispatch
File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\controllers\main.py", line 759, in get_list
File "C:\Program Files (x86)\OpenERP 7.0-20130328-001657\Server\server\openerp\addons\web\controllers\main.py", line 89, in db_list

Naresh Soni (nch) · Accepted Answer

Hi Neels,

This error states that the db user and db password that OpenERP server is using to connect to postgres is wrong. i.e check the server configuration file for the db_user and db_password are same as your postgres user and password.

Thanks,

marocsys · Answer

try this
$su postgres
$psql
*alter user openpg with password admin;
and go to odoo config file and write (db_password = admin

patrick · Answer

On Linux, you have to create a specific user within the database to allow openERP to access the database.

Command (on Linux) to create a user within postgreSQL:

createuser --createdb --username postgres --no-createrole --no-superuser --pwprompt openerp

You probably have to do something simular on Windows

Wahab Ali Malik · Answer

Hi,I know this is an old post but upper results are not working for me.Well this will definitely work.
You can see this django link => "https://stackoverflow.com/questions/34264003/peer-authentication-fails-with-postgressql-in-celery-task".

Apparently there are multiple ways for authentication with postgresql.

So,if your Postgresql user is different from your linux user then one easy way is to add `--db_host` to `localhost` which is `"127.0.0.1"`:

.odoo-bin -r "pg_user" -w 'pg_pass' --db_host

This question has been flagged

Enjoying the discussion? Don't just read, join in!