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

  4. Once you click on PostgreSQL 11, following window will appear
  5. 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

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

    Click to Enlarge

  6. 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