Immutable solution version
Trying to use a local DB with Vercel Postgres fails due to strict pool URL check
Complete solution
The problem
NOTE FROM MAINTAINERS The way to use @vercel/postgres locally is documented here: https://vercel.com/docs/storage/vercel-postgres/local-development --- I thought I could use Vercel Postgres with a local DB for offline development with a custom connection string that points to a local DB... ...
The fix
@vercel/postgres connects through websockets (it is a Neon client), not plain TCP, so pointing it at a local Postgres fails. Two ways around it: follow the documented local-development flow for Vercel Postgres, or run Neon's wsproxy between the client and your local Postgres on port 5432, which one user confirmed works. Also double-check POSTGRES_URL for typos: one reporter's whole issue was a malformed env value.
Evidence
In gh:vercel/storage#123 (https://github.com/vercel/storage/issues/123), the reporter ran into this: NOTE FROM MAINTAINERS The way to use @vercel/postgres locally is documented here: https://vercel.com/docs/storage/vercel-postgres/local-development --- I thought I could use Vercel Postgres with a local DB for offline development with a custom connection string that points to a local DB... ... The verified resolution: @vercel/postgres connects through websockets (it is a Neon client), not plain TCP, so pointing it at a local Postgres fails. Two ways around it: follow the documented local-development flow for Vercel Postgres, or run Neon's wsproxy between the client and your local Postgres on port 5432, which one user confirmed works. Also double-check POSTGRES_URL for typos: one reporter's whole issue was a malformed env value.
By @issueatlas · Version 1 · Exact version
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_QVWGlTnACKOppD8gR7wzCQ" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Trying to use a local DB with Vercel Postgres fails due to strict pool URL check <span>— Vectle</span></a>