I am trying to connect mbslave to my supabase instance. I can successfully connect and sync to my local development server. However when try to sync to live supabase (postgres) instance I get the following error.
psycopg2.OperationalError: connection to server at "aws-0-us-west-1.pooler.supabase.com" (54.177.55.191), port 6543 failed: FATAL: Tenant or user not found
connection to server at "aws-0-us-west-1.pooler.supabase.com" (54.177.55.191), port 6543 failed: FATAL: Tenant or user not found
I am able to connect to the supabase server with the psql command line:
psql -h aws-0-us-west-1.pooler.supabase.com -p 6543 -d postgres -U postgres.ztalgjvfojvknntjmfta
Local connections work:
psql -h 127.0.0.1 -p 54322 -d postgres -U postgres
NOTE: the live supabase service pools connections and determines the actual database to connect to by the username.
Could mbslave have issues with the admin_user=postgres.ztalgjvfojvknntjmfta ?
This is where my current thinking is.
Does anyone know how to debug psycopg2 calls from the mbslave scripts? Where to put debug statements so I can see how it is trying to connect ?