Can't link my local project to cloud, help me troubleshoot
I'm trying to link my local project to supabase cloud but in this process I faced, and still facing, multiple issues: 1- I created my project in supabase cloud and successfully linked to my local project, but when I started the migration it complained a table had multiple primary keys (which it hadn't). I couldn't get how to solve it so I removed all migration files and generated one single migration file again. Tried again but complained "remote migrations versions not found in local migrations directory". So I decided to create a new project in supabase cloud and start fresh. 2- I create a new project in supabase cloud, in the germany server. Unlinked local supabase to the previous project and when trying to link to the new project I got this error:
failed to connect as temp role: failed to connect to `host=aws-1-eu-central-1.pooler.supabase.com user=cli_login_postgres.<my project id> database=postgres`: dial error (dial tcp 3.65.151.229:6543: connect: connection refused)
failed to connect as temp role: failed to connect to `host=aws-1-eu-central-1.pooler.supabase.com user=cli_login_postgres.<my project id> database=postgres`: dial error (dial tcp 3.65.151.229:6543: connect: connection refused)
tried multiple times in the span of an hour but nothing worked. Then I thought my login credentials might be wrong (since the connection is being refused), so with:
npx supabase login
npx supabase login
opened a new browser, introduced the code, and got a 404 error in the CLI.
At this point I feel helpless and whatever I try supabase does not work.
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.