It seems you're encountering a common issue with Odoo's database connection requirements.

  Ensure that the user has the necessary privileges to connect to the 'postgres' database, as Odoo typically checks this during startup.

  If modifying privileges is not possible, consider setting up a local PostgreSQL instance where you have full control, and then migrate your data to Clever Cloud once configured.

  Alternatively, consult Clever Cloud's support for a workaround or additional permissions needed for Odoo's requirements.

If you’d like to explore this further for your use case, you’re welcome to connect with us at Pragmatic Techsoft.

This error is coming directly from PostgreSQL permissions.

FATAL:  permission denied for database "postgres"

DETAIL:  User does not have CONNECT privilege

Why it happens:

On most managed providers (like Clever Cloud, Heroku, etc.), the default postgres database is reserved for internal use.

Your database user has no CONNECT privilege to it, so if your app tries to connect to postgres, PostgreSQL will block it.

Fix

You need to make sure your application connects to the right database name, not the system one.

Check the credentials provided by Clever Cloud:

Host (server address)

Port (like 50013)

Database name (often a random string, not postgres)

Username

Password

Update your connection string / DATABASE_URL in your app to use that actual database name. For example: postgresql://USERNAME:PASSWORD@HOST:PORT/DATABASENAME

Replace DATABASENAME with the one given in your Clever Cloud dashboard (not postgres).

If you really need to use another database, you’d have to grant CONNECT manually:

GRANT CONNECT ON DATABASE mydb TO myuser;

…but on hosted services, you usually can’t grant privileges on postgres. That’s why you must connect to your assigned database instead.

If your correct database name is bixdjXXXXXXXXXXX

But from the error message, your Odoo is trying to connect to the postgres database, which your user doesn’t have rights for.

>>Correct Odoo configuration

Update your odoo.conf so it uses the right database name:

[options]

db_host = bixdjXXXXXXXXXXX-postgresql.services.clever-cloud.com

db_port = 50013

db_user = u7mtpoXXXXXXXXXX

db_password = ******************

db_name = bixdjXXXXXXXXXXX

dbfilter = bixdjXXXXXXXXXXX

addons-path = addons

>>Important Notes for Odoo

db_name must be your actual Clever Cloud DB name (bixdjXXXXXXXXXXX), not postgres.

dbfilter = bixdjXXXXXXXXXXX is fine if you want Odoo to only work with this single DB.

If db_name is missing or wrong, Odoo will try to connect to postgres by default → causing the permission denied error you saw.

After fixing, restart your Odoo service. It should now connect to your Clever Cloud PostgreSQL database without hitting the postgres DB.