Unable to connect to database with custom role through vercel.
🔢DB Connections
Hi, i am trying to connect to my supabase server using vercel while using a custom role. I can connect using the normal postgres role in vercel and also I am able to connect to the database from my local machine with the specific role with server running locally and pgadmin using the custom role which means it is correctly setup. However when deployed on vercel with the specific role, supabase seems to always reject the connection. How can i connect with the specific role instead of the admin role?
Error:
Error:
DB connection error: Error: getaddrinfo ENOTFOUND "Host name here"
at /var/task/node_modules/pg-pool/index.js:45:11
at process.processTicksAndRejections (node:internal/process/task_queues:103:5) {
errno: -3007,
code: 'ENOTFOUND',
syscall: 'getaddrinfo',
hostname: "Host name here"
}
