To connect Postgres database from remote PC using PgAdmin tool
Please follow the below steps to connect Postgres database from remote PC using PgAdmin tool.
Stop the server and perform the steps.
1. Go to the location C:\\ManageEngine\\SupportCenter\\pgsql\\data, edit the file postgresql.conf and make the below changes.
change #listen_addresses = 'localhost' to listen_addresses = '*' and save the file.
2. From the same location C:\\ManageEngine\\SupportCenter\\pgsql\\data, edit the file pg_hba.conf and make the below changes.
# IPv4 local connections:
host all all 127.0.0.1/32 trust
From the above parameter, change 127.0.0.1/32 to 0.0.0.0/0 and save the file.
3. Start the server.
Note : In attached screen shot scp is installed in ' scp-k12r2-1 ' machine. ' pgadmin ' is installed in ' scp-w2k8r2-1 '
machine.
New to ADSelfService Plus?
Related Articles
Remote read only access to database for Postgres customers
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 allow ...
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 build 10538 , please use the below method. psql -h localhost -U sdpadmin -p 65432 ...
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 ...
Query Executor Tool for Postgres
Overview: A query executor tool for PostgreSQL that allows for query execution without a direct database connection enhances security and flexibility while collaborating on query testing without the need for each team member to have direct database ...
How to Connect External Postgres
To install an external PostgreSQL server, ensure the PostgreSQL version matches the inbuilt PostgreSQL version series of the ServiceDesk Plus application. For example: If ServiceDesk Plus version is 14010 with PostgreSQL version 10.21, install an ...