I am using the Natural Language PostgreSQL template by Vercel: Natural Language Postgres
When I connect my Heroku-hosted database, I get an Vercel Postgres error related to the pooled connection string. I have enabled pooled connection for my Heroku database. Do I need to use Vercel Postgres database hosting in order to use the SDK?
The error:
⨯ Error [VercelPostgresError]: VercelPostgresError - ‘invalid_connection_string’: This connection string is meant to be used with a direct connection. Make sure to use a pooled connection string or try createClient() instead.
In my env. file:
POSTGRES_URL=PATH_TO_HEROKU_DB
POSTGRES_URL_NON_POOLING=PATH_TO_HEROKU_DB_NON_POOLING
