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
local all all md5
Can someone help me to create a new server ? And also help me to understand this little bit.