Error While connecting default Postgres Database

Error While connecting default Postgres Database

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.
          • Related Articles

          • How to Connect to SDP MSP Database ?

            1. In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\ServiceDeskPlus-MSP\pgsql\bin and run the below command                                     From SDP MSP version 10.6 , please use the below method.     ...
          • Remote read only access to database for Postgres customers

            Use case: Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to ...
          • Cannot run program "python" or Can't find a default python

            Use case While trying to run a python script, this error can be found. It usually occurs when the python is not installed/set up properly. Solution Try specifying the complete path of the python.exe instead of py and then in the argument specify the ...
          • Connect to default PGSQL database remotely

            1. To be able to reach the server remotely you have to add the following line into the file: ManageEngine/ServiceDeskPlus-MSP/pgsql/data/postgresql.conf:   listen_addresses = '*'   2. PostgreSQL, by default, refuses all connections it receives from ...
          • Set default Font Family and Font Size for all html editors

            This fix is applicable ONLY from version 10.5 (10500). Set default font is only for all html editors in the application like like incident description, resolution area, reply templates, resolution templates, all notifications and etc wherever html ...