Skip site navigation (1) Skip section navigation (2)

Re: odbc access and pg_hba.conf

From: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
To: Adrian Klaver <aklaver(at)comcast(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org,pgsql-odbc-owner(at)postgresql(dot)org
Subject: Re: odbc access and pg_hba.conf
Date: 2009-11-19 19:33:03
Message-ID: OF85686453.C2A4B1AA-ON85257673.006B4208-85257673.006B65BF@ssss.gouv.qc.ca (view raw or flat)
Thread:
Lists: pgsql-odbc
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 
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144
steve(dot)toutant(at)inspq(dot)qc(dot)ca
http://www.inspq.qc.ca
 




Adrian Klaver <aklaver(at)comcast(dot)net> 
19/11/2009 02:00 PM

A
Steve Toutant <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca>
cc
pgsql-odbc(at)postgresql(dot)org, pgsql-odbc-owner(at)postgresql(dot)org
Objet
Re: [ODBC] odbc access and pg_hba.conf











----- "Steve Toutant" <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca> wrote:

> 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?

Adrian Klaver
aklaver(at)comcast(dot)net



In response to

pgsql-odbc by date

Next:From: Raymond O'DonnellDate: 2009-11-19 19:37:50
Subject: Re: odbc access and pg_hba.conf
Previous:From: Steve.ToutantDate: 2009-11-19 19:26:32
Subject: Re: odbc access and pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group