Hasura tries to use DB username `postgres` despite other creds in HASURA_GRAPHQL_DATABASE_URL

Which env vars controls the database username will be used to connect?

In my env, it seems to only want to use the postgres username. In the Hasura docs, I see the HASURA_GRAPHQL_DATABASE_URL and HASURA_GRAPHQL_METADATA_DATABASE_URL env vars should be the way to use the creds you expect, but when I use a non-postgres username there, the deploy fails and the error says it’s trying to use postgres.

{"detail":{"code":"postgres-error","error":"connection error","internal":"connection to server at \"my-environment-endpoint.com\" (the-ip-address), port 5432 failed: FATAL:  password authentication failed for user \"postgres\"\nconnection to server at \"my-environment-endpoint.com\" (the-ip-address), port 5432 failed: FATAL:  password authentication failed for user \"postgres\"\n","path":"$"},"level":"error","timestamp":"2024-09-24T13:22:05.203+0000","type":"scheduled-trigger"}

I’ve also tried to set PGUSERNAME and POSTGRES_USERNAME.

Hello @NewAlexandria,

I’m Charles-Edouard TAM @Qovery.

I just checked your environment and it looks like everything is working.

Can you confirm that you resolved the problem?

Regards,
Charles-Edouard