Re: [QUESTIONS] postgresql-6.3 and jdbc - grief

Pter Mount wrote:
> On Fri, 13 Mar 1998, Stephan B. Doliov wrote:
> > I know i must be doing something inanely stupid but the jdbc driver that
> >
> > in pg_hba.conf i have
> > local all password password
> > host all 198.11.51.133 255.255.255.224 password password
> This is your problem, the IP address & mask don't match (for postgresql's
> purposes).
> If you are trying to say: only 198.11.51.133 is to have access, then it
> should read:
> host all 198.11.51.133 255.255.255.255 password password
> but, if you are saying that the network that 198.11.51.133 resides is to
> have access, and 255.255.255.224 is the netmask, then this should read:

thanks for clarifying my consfusion regarding netmasks (i just did an
ifconfig -a on my le0 (ethernet) interface and saw the netmask ws
ffffffe0) and so thought that is what i should put in the pg_hba.conf
file.

however - the mystery i still have not yet been able to solve is why do i
have to speccify the host in the url in order to get the jdbc driver to
work.
jdbc:postgresql:funnystuff fails
jdbc:postgresql://198.11.51.133/funnystuff works.

pg_hba.conf reads:
local all password password
host all 198.11.51.133 255.255.255.225 password password

is it because poastmaster is running with the -i option? if i let the
pg_hba.conf file for local read
local all trust
i don't need to specify the hostname in the url.

by and large, i can live with this no problem, it's just that my curiosity
has been greatly aroused by the observed behavior.

cheers,
steve