search

vercel / storage

Vercel Postgres, KV, Blob, and Edge Config
https://vercel.com/storage
Apache License 2.0
517 stars 57 forks source link

Connect to vercel postgress from db client (pgadmin | dbeaver) #766

Closed marcosdipaolo closed 2 months ago

marcosdipaolo commented 2 months ago

Hey there. I'm on the process of create a local postgress instance with docker so I'm not connecting to vercel's db all the time working locally. Unfortunately I don't have an ORM/migrations setup yet, so I wonder what would be the right way to do this considering that my remote db already has some tables and data. My first approach was to dump the remote db and then restore it locally, but unfortunately I tried to connect with pgadmin and dbeaver and they all timeout. What could be the reason?

Another approach? Any way of dumping the db from the dashboard?

Edit: I also tried with pg_dump and got:

pg_dump: error: connection to server at xxxxxxxxxxxxxxxxxxxxx (xx.xxx.xxx.xx), port 5432 failed: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.