Your PostgreSQL Server must be configured to allow data to be sent to and from from other servers/computers on your local network. To connect to this server from another computer on your network, you need to know the server's address. Follow the instructions from IP Address from the Local Network to determine the address of the computer which is used to host the PostgreSQL server.
The first step is to determine how your network is setup.
# TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: #host all all ::1/128 md5
host all all 192.168.0.0/24 md5
host all all 192.168.1.0/24 md5
We will now update a different PostgreSQL configuration file to let the server know that any IP addresses found within the approved subnet (local network) will be allowed access to the SQL server.
Open the postgresql.conf configuration file in Notepad by clicking Start -> Programs -> PostgreSQL-> Configuration Files -> postgresql.conf, or in the folder C:\Program Files\PostgreSQL\9.0\data. (Replace 9.0 with the version of PostgreSQL that you have.)
Scroll to the bottom of the file and add the following line of text:
listen_addresses = '*'
This line of text tells your PostgreSQL server to listen on ALL addresses your computer has, not just localhost (which is only accessible from the local computer).