search

takanome-dev / astro.go.blog

Blog app with Astro 🚀 on the front and Go 🐹 on the back
https://blog-with-astro-golang.vercel.app/
MIT License
33 stars 5 forks source link

db migration failed in windows #108

Open abhinavpatel0 opened 4 months ago

abhinavpatel0 commented 4 months ago

Describe the bug

when i tried to migrate db with goose postgres DB_URL=postgres://postgres. :@aws-0-us-east-1.pooler.supabase.com:6543/postgres up it gives me this

2024/06/30 20:28:39 goose run: failed to connect to host=localhost user=hp database=: dial error (dial tcp 127.0.0.1:5432: connectex: No connection could be made because the target machine actively refused it.)

Steps to reproduce

following readme

Browsers

No response

Additional context (Is this in dev or production?)

No response

Contributing Docs

takanome-dev commented 4 months ago

Hey @abhinavpatel0, thanks for opening this. Looks like this is has to do with the db url.

Is your postgres db actually running on port 6543?

I'm also concern about the error. Why is it trying to connect to localhost?

If you are still having this issue, can you please provide more details

abhinavpatel0 commented 4 months ago

my db url is something like postgres://postgres. :@aws-0-us-east-1.pooler.supabase.com:6543/postgres

i m using postgres url taken from supabase i am not running the db locally