Hello,
I am trying to deploy Odoo in Clever Cloud, an European cloud provider.
Clever Cloud has a managed PostgreSQL service, where you get a PG instance. In order to connect to it, they give you the host, port, user password and database name. I have owner right on that database, but no right to create or connect any other database on the host. And that's the part is blocking me to deploy Odoo on it, it seems that Odoo needs to have connect access to a database named 'postgres' in the database host.
That's my config file:
[options]db_host = bixdjXXXXXXXXXXX-postgresql.services.clever-cloud.com
db_port = 50013
db_user = u7mtpoXXXXXXXXXX
db_password = ******************
db_name = bixdjXXXXXXXXXXX
dbfilter = bixdjXXXXXXXXXXX
database = bixdjXXXXXXXXXXX
addons-path=addons
I have tried with db_name only, database only and both, same result.
I have tried also passing the --database option to the command line, but I always find the same error :
2025-08-27T11:28:05.202Z: psycopg2.OperationalError: connection to server at "bixdjXXXXXXXXXXX-postgresql.services.clever-cloud.com" (xx.xx.xx.xx), port 50013 failed: FATAL: permission denied for database "postgres"
2025-08-27T11:28:05.202Z: DETAIL: User does not have CONNECT privilege
What am I doing wrong?
Hmm, configuration seems valid for me.
Could you try passing the `--no-database-list` parameter when starting Odoo?
That's my current command line `python3 odoo-bin -c ./clevercloud/odoo.conf --no-database-list --database=bixdjXXXXXXXXXXX`
Tried also @Dawid Gacek solution, didn't work:
2025-08-27T14:01:40.764Z: Running `python3 odoo-bin -c ./clevercloud/odoo.conf --no-database-list -i base --db-filter=bixdj7mlnllvfru6thv0 --database=bixdj7mlnllvfru6thv0` instead of WSGI
2025-08-27T14:01:42.674Z: 2025-08-27 14:01:42,674 2790 INFO ? odoo: Odoo version 18.0
2025-08-27T14:01:42.675Z: 2025-08-27 14:01:42,675 2790 INFO ? odoo: Using configuration file at /home/bas/app_b51005d8-da63-40b8-992a-a38672136334/clevercloud/odoo.conf
2025-08-27T14:01:42.675Z: 2025-08-27 14:01:42,675 2790 INFO ? odoo: addons paths: ['/home/bas/app_b51005d8-da63-40b8-992a-a38672136334/odoo/addons', '/home/bas/.local/share/Odoo/addons/18.0', '/home/bas/app_b51005d8-da63-40b8-992a-a38672136334/addons']
2025-08-27T14:01:42.675Z: 2025-08-27 14:01:42,675 2790 INFO ? odoo: database: u7mtpoena6btco6u92hw@bixdj7mlnllvfru6thv0-postgresql.services.clever-cloud.com:50013
2025-08-27T14:01:42.713Z: 2025-08-27 14:01:42,712 2790 INFO ? odoo.sql_db: Connection to the database failed
I have reproduced your problem locally.
Please update the name of
dbfilter
parameter todb-filter
, as the parameter with namedbfilter
does not exsist.If this alone won't help, try to initialize your database:
Best Regards,
Dawid Gacek
But I already have the name in db_name, as shown in my config file.
I have looked ad your config file example, and I don't see any differences with mine. And it still insists to connect to 'postgres'.
Same thing if I try to force the database name in the commande line with -d or --database.
And in the code, I see lots of references to db_connect('postgres') that seems to indicate that it connects to the db called 'postgres'.