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?