Trouble with pg_hba.conf and Access. - Mailing list pgsql-novice

From Neal Lindsay
Subject Trouble with pg_hba.conf and Access.
Date
Msg-id 5.1.0.14.0.20010709150554.00a0dec0@mail.peaofohio.com
Whole thread Raw
Responses Re: Trouble with pg_hba.conf and Access.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
I am currently getting the following error when trying to connect to my
PostgreSQL server on my LAN via Microsoft Access and ODBC.

No pg_hba.conf entry for host 192.168.0.100, user neal, database mydb (#210)

The confusing thing is that I have set up my pg_hba.conf file in my data
directory.  The actual text follows:

local    all    trust
host    all    192.168.0.0    255.255.255.0    trust
host    all    127.0.0.1    255.255.255.255    trust

I tried various other options, like enabling all hosts, and nothing seems
to work.  Is this a quirk with Access 97?


pgsql-novice by date:

Previous
From: "Boleslaw Bakowski"
Date:
Subject: Postgres and Linux 7.1
Next
From: Tom Lane
Date:
Subject: Re: Trouble with pg_hba.conf and Access.