Subject: CRITICAL: Persistent Authentication Failure (Tenant/User Not Found) connecting to Pooler
🔢DB Connections
Project Reference:
Region:
Problem:
My FastAPI backend application is consistently rejected by the Connection Pooler with the error
Connection and Network Context:
1. Direct Connection Blocked: The direct database host (
2. Pooler Host Used: I am successfully reaching the Pooler host (verified by eliminating the previous Timeout Error).
3. Host Used:
4. Port Used:
Authentication Testing (All Failed with the same "Tenant or user not found" error):
| Credentials Tested | User in URL | Password/Key in URL | Database Name |
| Standard User/Simple Pass |
| Service Role Key (Standard DB) |
| Service Role Key (Ref ID DB) |
| Final Test |
wdqcqxixxxxxxxxxRegion:
ap-northeast-2Problem:
My FastAPI backend application is consistently rejected by the Connection Pooler with the error
asyncpg.exceptions.InternalServerError: Tenant or user not foundConnection and Network Context:
1. Direct Connection Blocked: The direct database host (
db.*2. Pooler Host Used: I am successfully reaching the Pooler host (verified by eliminating the previous Timeout Error).
3. Host Used:
aws-1-ap-northeast-2.pooler.supabase.com4. Port Used:
5432Authentication Testing (All Failed with the same "Tenant or user not found" error):
| Credentials Tested | User in URL | Password/Key in URL | Database Name |
| Standard User/Simple Pass |
postgres[PASSWORD]postgres| Service Role Key (Standard DB) |
service_role[SUPABASE_KEY]postgres| Service Role Key (Ref ID DB) |
service_role[SUPABASE_KEY]wdqcqxiynasrtvvdfnxf| Final Test |
postgres[Service Role Key]postgresUntitled_document_3.pdf56.08KB
