Error While connecting postgresDB

If you are getting the below error while connecting the postgresDB , please follow the steps below :

Error :

psql: FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “servicedesk”,SSL off

 

 

Please open pg_hba.conf under [ServiceDesk Plus – MSP_HOME]\pgsql\data using word pad or using an editor. Then find for the below

# IPv6 local connections:
#host    all             all             ::1/128                 trust

Change it to the below. That means remove # before host keyword

# IPv6 local connections:
host    all             all             ::1/128                 trust

Save the document and then try to start the pgsql server and then connect to the database.

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500