password auth failed for user "pgadmin" i think issue that psql server password contains #, $, %
Hi everyone!
I'm deploying Coder on Kubernetes and using Azure Key Vault + External Secrets to inject the PostgreSQL connection string into Coder.
However, my PostgreSQL password contains special characters like #, $, %. When Coder tries to connect, it fails with:
pgsql
pq: password authentication failed for user "pgadmin"
How does Coder handle PostgreSQL connection strings with special characters in passwords?
Should the password be URL-encoded in the connection string?
Is there a known workaround for handling long passwords with special characters?
Would love to hear any insights from the community! Thanks in advance.
4 Replies
<#1346810124894863442>
Category
Help needed
Product
code-server
Platform
Windows
Logs
Please post any relevant logs/error messages.
hm sorry error is for parsing connect to postgres: escaping postgres URL: parse postgres url: parse "postgres://pgadmin:***": invalid port "**" after host
error show my password until # character in my password
hello, yes it needs to be url-encoded to avoid these issues in the postgres connection URI
try using https://www.urlencoder.org/
URL Encode
URL Encode and Decode - Online
Encode to URL-encoded format or decode from it with various advanced options. Our site has an easy to use online tool to convert your data.