Re: first time odbc

This is my pg_hba.conf file. I replaced x's with my ip address.
If I comment line 74, then no one can odbc to postgresql.
Lines 1 - 67 are all just commented text.

 68 # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
 69 
 70 # "local" is for Unix domain socket connections only
 71 local   all         all                               trust
 72 # IPv4 local connections:
 73 host    all         all         127.0.0.1/32          trust
 74 host    all         all         xxx.xxx.xxx.xxx 255.255.0.0       md5
 75 # IPv6 local connections:
 76 host    all         all         ::1/128               trust


-----Original Message-----
From: Raymond O'Donnell [mailto:rod@iol.ie] 
Sent: Wednesday, March 30, 2011 8:48 AM
To: Marc Fromm
Cc: postgresql@finner.de; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] first time odbc

On 30/03/2011 15:54, Marc Fromm wrote:
> I only want the users to read data, thus I removed superuser and 
> applied grant select.

Good stuff.

> If the listen_address is not a client filter, would it still be better 
> to only have it listen to localhost and the few ip addresses that will 
> need to odbc to the postgres database? Is it just not possible to 
> assign listen_address = 'localhost, 1.ip.address, 2.ip.address'?

You're still misunderstanding listen_addresses - it has *nothing* to do with client addresses.

Example: I have a server with two network interfaces, a.b.c.x and a.b.c.y. If I want PG to listen on both interfaces, I
canset listen_addresses = '*' (or list the two addresses explicitly). If I want it to listen *only* on a.b.c.x, then I
setlisten_addresses='a.b.c.x'.
 

> One other thing still, if in the pg_hba.conf file I do not include any 
> ip addresses I cannot connect to the database. If I enter just one ip 
> address, any computer can connect to the database, even though some 
> machines have static ip addresses and others have dhcp address from a 
> completely different subnet. Do you know why this is? I figured the 
> pg_hba.conf file controlled access by ip address, based on other 
> googled articles.

Can you show us your pg_hba.conf?

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie