Connect to default PGSQL database remotely

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 any remote address. You have to relax these rules by adding this line to [ServiceDesk Plus - MSP HOME]/pgsql/data/pg_hba.conf:

 

host all all  0.0.0.0/0 md5

So, after modifications, it should look like below,


host    all             all             127.0.0.1/32            md5

host    all             all             0.0.0.0/0                md5  

This is an access control rule that lets anyone login from any address if a valid password is provided (the md5 keyword). You can use your network/mask instead of 0.0.0.0/0 to only allow access from certain IP addresses.

 

3. When you have applied these modifications to your configuration files, you need to restart the PostgreSQL server.

 

Now, you will be able to login to your server remotely.


          • 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.     ...
          • 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 ...
          • 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 ...
          • 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 admin and execute  command to start the data backup. ...
          • How do I convert the database from MSSQL to PGSQL ?

            Kindly plan to perform this process ONLY during Non Operational hours. You can do this process in the same server that you have SDP MSP installed. Step 1:  Stop the application and Take a backup of the existing data in the application. Navigate to ...