Unable to add a new connection to server in PostgreSQL using pgAdmin
0
votes
1
answer
5586
views
I am new to PostgreSQL and trying to configure it. After installing the PostgreSQL. I am trying to add a new connection to server using pgAdmin. I know there is a by default created on port 5432 but I change this port to 5433. And trying to configure all my database on this port. And through terminal this is working.
But when I am trying to add a new connection to a server it throws
09:56:56: Error: Error connecting to the server: FATAL: password authentication failed for user "tars"
FATAL: password authentication failed for user "tars"
I have already followed this thread here. And also tried configuring pg_hba.conf. Changed this line
local all all peer
to
local all all md5
But couldn't add a new connection.
This is the screenshot, the way I am trying to configure
Can someone help me to create a new server ? And also help me to understand this little bit.


Asked by Lokesh Pandey
(197 rep)
May 29, 2018, 04:37 AM
Last activity: May 29, 2018, 09:16 AM
Last activity: May 29, 2018, 09:16 AM