22 days ago
user denied accessfor 12 dbs in my project
4 Replies
22 days ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open Railway • 22 days ago
22 days ago
This is not a DB deployment issue directly. It is an environment variable loading issue.
Your deployed app is probably not receiving the correct DB credentials, so it tries to connect with empty/default values or the wrong user. That is why all 12 databases return “user denied access.”
Fix:
- Add the DB credentials/environment variables in the deployment platform’s environment settings.
- Make sure the variable names match the code exactly.
- Redeploy/restart the service after saving them.
- Check that the DB user has privileges on all 12 databases.
- Do not use localhost in production DB URLs. Use the hosted/internal DB connection URL from the platform.
After the env vars are correctly available at runtime, the DB access errors should stop.
22 days ago
EVERYTHING IS THERE,STILL ISSUE NOT RESOLVED,PGUSER ENV IS NOT RESOLVING,SHOWING AS EMPTY STRING
22 days ago
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: sorry, too many clients already
22 days ago
- psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: role "root" does not exist