What Password does Session Connection Expect

I am attempting to restore a backup to a new Supabase project, so I'm following the guide at https://supabase.com/docs/guides/platform/migrating-within-supabase/dashboard-restore.

However after connecting via Session Pooler String like so:

PGPASSWORD='[my_password_which_has_special_characters]' psql -h aws-0-eu-central-1.pooler.supabase.com -p 5432 -U postgres.my_project_id -d postgres

I get another prompt for a password

Password for user postgres.my_project_id

I've tried

  • the same database password as 'PGPASSWORD' in the initial command
  • my service role key
  • my anon key
They all seem to be incorrect

psql: error: connection to server at "aws-0-eu-central-1.pooler.supabase.com" (52.59.152.35), port 5432 failed: error received from server in SCRAM exchange: Wrong password

Any ideas guys?

Additional context: no I did not just recently set/reset my database password
Was this page helpful?