Sample Header Ad - 728x90

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. enter image description here 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 enter image description here 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