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?