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