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.


      New to ADSelfService Plus?

      Start your free trial

        Resources

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

            • How to connect to external postgres(external DB)

              1. From the postgres installed path navigate to bin folder and open a command prompt 2. Execute the command --> pg_ctl -D "C:\Program Files\PostgreSQL\10\data" start (Postgres server gets started) 3. Connect to DB using the command-->psql -U postgres ...

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

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

            • How do I convert the database from PGSQL to MSSQL?

              1. Stop ManageEngine ServiceDeskPlus – MSP service. 2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute  command to start the data backup. ...