CODEWITHSUNDEEP
postgresqlazureazure-database-postgresql
Shantanu
Shantanu

Reputation: 2931

Connection to Azure postgres server fails in spite of correct username

When trying to connect to my postgres server in Azure from psql client, I get the following error, even though I am using the correct username. How can I fix this?

psql: FATAL: Invalid Username specified. Please check the Username and retry connection. The Username should be in <username@hostname> format.

Upvotes: 14

Views: 13893

Answers (3)

Stavros Koureas
Stavros Koureas

Reputation: 1472

In general, I have concluded that while trying to connect into PostgreSQL, you need to follow this username pattern: username@hostname. For newer versions of postgresql (after v11) this is not prerequisite and you can use only as per documents. But the word prerequisite, I think is wrong, as for every PostgreSQL v15 the username must be . Finally if the host is localhost, the username should be even for older versions.

Upvotes: 0

Kevin Burandt
Kevin Burandt

Reputation: 1990

The @ sign in username works fine for objects but not connect strings. According to URI RFC-3986 username allows hex encoding. So replace the @ with %40. user@host:pw@fullhost becomes user%40host:pw@fullhost

Upvotes: 12

Shantanu
Shantanu

Reputation: 2931

As noted in the error text, you are required to follow the <username@hostname> format when trying to connect to postgresql server, whether you are doing it from psql client or using pgadmin. Using <username@hostname> format instead of just <username> should get rid of the error.

Read the quick-start documents for Azure portal and CLI to understand more about how to create and configure your postgres server.

Upvotes: 17

Related Questions