Hi, I'm trying to deploy odoo18 on heroku, I've added a Procfile on the root of odoo with this line :
web: python3 odoo-bin --config=odoo.conf
then on my root I created a odoo.conf file like this :
[options]
db_user = my postgres db user
db_password = my postgres passw
db_host =my db host
db_port =5432
db_name = my dynamo
addons-path=addons
but I keep getting this error when I run odoo:
2025-02-04T17:10:11.215872+00:00 app[web.1]: psycopg2.OperationalError: connection to server at "(mydbhost)" (mydbhostip), port 5432 failed: FATAL: permission denied for database "postgres"
2025-02-04T17:10:11.215873+00:00 app[web.1]: DETAIL: User does not have CONNECT privilege.
2025-02-04T17:10:11.215873+00:00 app[web.1]:
2025-02-04T17:10:11.368498+00:00 heroku[web.1]: Process exited with status 1
2025-02-04T17:10:11.391071+00:00 heroku[web.1]: State changed from starting to crashed
how can I fix this? thx
