Tag Archives: remote

Connecting Postgres remotely through pgAdmin III

I’m new at postgre. I have installed Postgres to my server machine. It has nice and effective client interface, which is pgAdmin III. I have worked on it, where postgre DB server and pgAdmin III are in same machine. But, now I need connect with the server machine. Which means, my db server is in the server machine which is in CentOS 5.5 x64 and pgAdmin in my client machine which is Win 7. Let’s see if I can do this.

I googled to solve my purpose and found that I need to edit ‘ pg_hba.conf ‘. I have to make entry of my client machine. To be precise, my client machine ip is 172.20.1.60 , I have to put this ip to pg_hba.conf, so my client machine will be permitted to connect to the server.

I found it in ‘ /opt/PostgresPlus/9.0SS/data/ ‘.

Read more of this post

Advertisements