Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's?

[Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx>]

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