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

ODBC and Postgres 7

From: John VanDyk <jvandyk(at)iastate(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: ODBC and Postgres 7
Date: 2000-06-09 15:03:10
Message-ID: v04220803b566a7f8011e@[129.186.120.53] (view raw or whole thread)
Thread:
Lists: pgsql-novice
My goal is to set up Postgres 7 on Red Hat 6.2 and access it via ODBC from an NT machine.

I've set up PostgreSQL and it seems to be working. I can create the test database and manipulate it.

I created a pg_hba.conf file in /usr/lib/pgsql using the pg_hba.conf.sample file as a starting point. I added a line that looks like this

host         all         1.2.3.4 255.255.255.0      trust

where 1.2.3.4 is the IP of my NT machine. I set up the ODBC driver and I can do a query but get the response

{error} STATE=28000, CODE=210, MSG=No pg_hba.conf entry for host 1.2.3.4, user skippy, database test

What have I missed? I thought the "all" took care of all users from 1.2.3.4.

Thanks in advance,

John

pgsql-novice by date

Next:From: Kevin LoDate: 2000-06-09 15:38:10
Subject: Re: any tutor/samples for installing/starting/programmingonNT ?
Previous:From: Colin WoolmerDate: 2000-06-09 05:51:35
Subject: Re: : permission denied initdb: 34: Syntax error: Bad fd number

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