Hello Ben Quan,

You have to set db_password which you have created in pgadmin for user odoo and then create your database within odoo and there will you set your custom user and password.

trying these commands in terminal

$su postgres

$psql

*alter user odoo with password admin;

and go to odoo config file and write (db_password = admin,db_host = localhost,

db_port = 5432)

Creating Postgres User For Odoo

Thank you

Thanks Pinal

I tried setting db_password. The file now reads:

[options]

; This is the password that allows database operations:

; admin_passwd = admin

db_host = False

db_port = False

db_user = odoo

db_password = mypassword

;addons_path = /usr/lib/python3/dist-packages/odoo/addons

I then deleted the database and recreated it using Odoo. But still same redult : FATAL: password authentication failed for user "odoo"

Ben