Deploy on Heroku, error on db connection

Question

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)"

lyly · 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 us

관련 게시물	답글	화면
How to share cash payment method with all the Shop point in POS module in Odoo 18? odoo18	1 8월 25	279
Odoo can’t be reached via MyIP:8069 odoo18	0 7월 25	496
Status bar not visible in odoo18, is there any missing library support or anything please let me know, statusbar is not visible in my local enviroment of odoo18 in all views. odoo18	0 7월 25	1136
Auto Session time out for users ODOO 18 odoo18	1 4월 25	1642
company changing from Private Limited to Public Limited during Middle 해결 완료 odoo18	1 6월 25	1088

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!