I I remove this line the client doesn't have access. host all dbaInspq 10.2.195.37 255.255.254.0 md5
But I don't understand why. Maybe because of 255.255.254.0
I probably misunderstood the option I should put in this hba.conf
what do you think? thanks steve
Steve Toutant, M. Sc. Analyste en géomatique Secteur environnement Direction de la santé environnementale et de la toxicologie Institut national de santé publique du Québec 945, avenue Wolfe Québec, Qc G1V 5B3
> the first line is host all all 127.0.0.1/32 md5 > > So the full hba.conf is > > host all all 127.0.0.1/32 md5 > host all dba xxx.xxx.xxx.xxx 255.255.255.0 md5 > host all dba yyy.yyy.yyy.yyy 255.255.254.0 md5 > > > > xxx.xxx.xxx.xxx is the ip address of the server running postgres > > > >
> > > > Thanks for your help, > > steve > >
In addition to what Richard said, what is the network that the client is running on?