Skip to Content
Menu
This question has been flagged
1 Odpoveď
1086 Zobrazenia

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

Avatar
Zrušiť
Best Answer

Hi Fabio, it looks like the error comes from your database configuration — specifically, the PostgreSQL user you're using doesn’t have the CONNECT privilege on the "postgres" database. Double-check that the db_name in your odoo.conf is set to the name of the actual Odoo database (not "postgres", which is usually a default admin DB). Also, make sure that your PostgreSQL user has the correct privileges for that database. You might need to create a new database and grant full access to your Odoo user. Let me know if you need help with the SQL commands to do that!

Avatar
Zrušiť

Let me know if you need help with the SQL commands to do that! https://retrobowl25.com

Related Posts Replies Zobrazenia Aktivita
1
apr 25
961
0
mar 25
612
1
feb 25
747
0
feb 25
1035
0
máj 25
821