Postgres Pro
Downloads
Home   >   mailing lists

Re: odbc access and pg_hba.conf - Mailing list pgsql-odbc

From Steve.Toutant@inspq.qc.ca
Subject Re: odbc access and pg_hba.conf
Date
Msg-id OF85686453.C2A4B1AA-ON85257673.006B4208-85257673.006B65BF@ssss.gouv.qc.ca
Whole thread Raw
In response to Re: odbc access and pg_hba.conf  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-odbc
Tree view

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.toutant@inspq.qc.ca
http://www.inspq.qc.ca

 




Adrian Klaver <aklaver@comcast.net>

19/11/2009 02:00 PM

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










----- "Steve Toutant" <Steve.Toutant@inspq.qc.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@comcast.net



pgsql-odbc by date:

Previous
From: Steve.Toutant@inspq.qc.ca
Date:
Subject: Re: odbc access and pg_hba.conf
Next
From: Raymond O'Donnell
Date:
Subject: Re: odbc access and pg_hba.conf