Hi, as a DevOps Consultant, I want to run Odoo in a more hardened way. For me that implies, to work with an external database (e.g. AWS RDS) with a db user with least privileges possible (no "CREATEDB" role attribute).

So what I was trying now since two days on odoo 16 and odoo 17, installation from source, as well from debian packages (always community, no enterprise yet) is the following:

I run a dedicated postgres node.

I created an odoo_cc user and a odoo_demo database, which is accessable for the odoo_cc user from my odoo box.

I have set the following configuration in odoo.conf:

db_host = postgresql.my.domain

db_port = 5432

db_user = odoo_cc

db_password = MyPasswd

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

db_name = odoo_demo

list_db = False

For my understanding, that should deactivate the database manager and enforce odoo, to just make use of that one database "odoo_demo".

Sadly it is failing (on all four combinations) with the following error message:

failed: FATAL:  no pg_hba.conf entry for host "192.168.33.40", user "odoo_cc", database "postgres", no encryption

How do I need to configure odoo, if I want to fix it to one single database and what steps do I need to apply to initialize that database (if that is even necessary).

Since I'm currently experimenting with odoo, I'm still on the community edition, but planning to change to enterprise soon. I just want to have it under my own control and stable operability is key to us, as we want to make use of the website module as well and therefore run it public internet facing.