"FATAL: Tenant or user not found [SOLUTION]

[LucasKlemke]

I was trying to create a new user to connect on supabase using sql queries, but I was getting the following error when trying to connect "FATAL: Tenant or user not found .

CREATE USER joao WITH PASSWORD 'cachorroquente';
GRANT CONNECT ON DATABASE postgres TO joao;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO joao;

❌ postgresql://joao:[password]@aws-0-sa-east-1.pooler.supabase.com:6543/postgres
🚨 "FATAL: Tenant or user not found

I realized that, in order to be able to connect with the created user, instead of inserting the user on the username field, I had to also insert the characters from the default user postgres, after the dot:

postgresql://postgres.ooystigvanwktbjqnxhr:[password]@aws-0-sa-east-1.pooler.supabase.com:6543/postgres

✅ postgresql://joao.ooystigvanwktbjqnxhr:[password]@aws-0-sa-east-1.pooler.supabase.com:6543/postgres

[putrafajarh]

Where to get username?

[BITRU]

to user you add (or postgres that exist) DOT(.) and POOLER_TENANT_ID value from env.
so you have username: postgres.POOLER_TENANT_ID