Articles → POSTGRESQL → Connect To Postgresql Server

Connect To Postgresql Server






How To Connect?




  1. Open PgAdmin 4.
  2. Following window will appear
    3. Picture showing the pgadmin window
    Click to Enlarge

  3. Once you click on PostgreSQL 11, following window will appear
    4. Picture showing a popup window for entering the password of the server
    Click to Enlarge




  1. Open the file ‘pg_hba.conf’ (PostgreSQL\11\data folder).
  2. Scroll to the end of file. You will observe that method for all types of connections is ‘md5’.
    3. Picture showing the connections in the pg_hba.conf file
    Click to Enlarge

  3. Change md5 to trust
    4. Picture showing changing all the connections of the pg_hba.conf from md5 to trust
    Click to Enlarge

  4. Save and close the file.




Picture showing the pgadmin connected to server without password
Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, October 16, 2019

Query/Feedback


Your Email Id
 
Subject
 
Query/FeedbackCharacters remaining 250