How to make pgAdmin connection with PostgreSQL ?
I would like to discuss regarding pgAdmin connection with PostgreSQL.
We will go with screenshots one by one.
In first screen, I have opened pgAdmin, and clicked on “Connect” icon.
When we click on “Connect” button, following window will get appear in which we have to enter postgresql information.
Press “OK” button when done with information. You will get below error message because of PostgreSQL user authentication.
Now, lets solve this error by using following commands.
Once you completed this process from command line, do the same process for entering PostgreSQL information.
You will see the following screen with connection in pgadmin.