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

İlgili Gönderiler	Cevaplar	Görünümler
Auto Session time out for users ODOO 18 odoo18	1 Nis 25	907
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 Mar 25	595
company changing from Private Limited to Public Limited during Middle odoo18	1 Şub 25	716
Odoo18,in list view,select a record,from 'Actions' menu,select 'Delete',doesn't work properly odoo18	0 Şub 25	965
Odoo18 - How to select Email Templates when sending multiple invoices odoo18	0 May 25	803

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!