To connect Postgres database from remote PC using PgAdmin tool

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?

        Resources

            • Related Articles

            • How to Connect to SCP Database ? (from 11000 builds)

              In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\supportcenterplus\pgsql\bin and run the below command                                                                                               1.  If ...
            • Database migration from MySQL to Postgres/MSSQL in SCP 8.1

              We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...
            • How do I convert the database from PGSQL to MSSQL?

              1. Stop ManageEngine Supportcenter Plus 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. ...
            • How to connect to DB - 8121

              Connect to PostgreSQL Server in Windows: Go to [SupportCenter Plus Home] \ pgsql \ bin in the command prompt. -> C:\> cd ManageEngine\SupportCenter\pgsql\bin Enter the command: psql.exe -U postgres -p 65432 -h 127.0.0.1 supportcenter -> C:\> cd ...
            • How to Change default password on PGSQL database

              Please do follow the below steps which would assist you in changing the default Postgres password.  1. Stop the application services.   2. Please take a trimmed backup <OR> take a Snapshot of  the Server 3. Open Command Prompt with Admin Privileges ...