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

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