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:
I get another prompt for a password
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
Any ideas guys?
Additional context: no I did not just recently set/reset my database password
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 postgresI get another prompt for a password
Password for user postgres.my_project_idI'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 passwordAny ideas guys?
Additional context: no I did not just recently set/reset my database password
