On 03/09/2011 07:31 AM, John Edens wrote:
Hey guys, I'm trying to get a VB program to make a client connection to my PostgreSQL server running on an
Ubuntu 10.10 server....
listen_addresses = '*, 144.96.80.35, localhost'
Using * should be fine unless you have multiple IP addresses and want the *server* to *listen* on only some of those addresses - say localhost if you were running web and db on the same machine and didn't want to listen to connections from the outside. This setting only determines where the server listens.
I have added the following to pg_hba.conf:
# IPv4 local connections:
host all all 144.96.80.35 255.255.255.0 md5
local all postgres md5
This setting determines what *clients* are allowed to connect to the server. Your setting here is strange. It should be a proper network range. You have an IP address with a class-C netmask.
If you want to only accept connections from a specific single IP address, use 144.96.80.35/32 or 144.96.80.35 255.255.255.255. But if you want to listen to the class-C then 144.96.80.0/24 or 144.96.80.0 255.255.255.0.
And since the IP address you gave appears real since it is in the assigned public space for Stephen F. Austin State University, I hope this machine is hiding behind a firewall.
Cheers,
Steve