Description: I am trying to connect my n8n Cloud instance to a Supabase PostgreSQL database, but I keep receiving the error: "Tenant or user not found".
What I have tried:
-
Host: Switched from the direct connection string to the Connection Pooler (Transaction mode) provided by Supabase:
aws-0-eu-central-1.pooler.supabase.com. -
Port: Updated from 5432 to
6543. -
User: Tried both the short format (
postgres) and the full format (postgres.lgdvfoiczoiqojrqlyis). -
Password: Reset the database password in Supabase and updated it in n8n multiple times.
-
SSL: Toggled “Ignore SSL Issues (Insecure)” on and off.
Where the bug seems to be: The n8n instance successfully reaches the Supabase server (no more “Host not found” errors), but the connection is rejected at the authentication/tenant level. It seems like the n8n Cloud instance cannot correctly pass the tenant ID through the connection pooler or there is an IPv4/IPv6 compatibility issue that persists even with the pooler.
Environment:
-
n8n Version: Cloud (erantarielli.app.n8n.cloud)
-
Database: Supabase (PostgreSQL)