ODBC from win2k to postgres on Linux HELL

ODBC from win2k to postgres on Linux HELL

I get the following error message:

 no pg_hba.conf entry for host 192.168.0.4 user postgres database gims_dev

despite the following line is in the pg_hba.conf file.

 host    all     192.168.0.4     255.255.255.255 trust

I restarted the server too.

Very frustrated...



________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag


---- On Wed, 6 Mar 2002, Patrick Welche (prlw1@newn.cam.ac.uk) wrote:

> On Wed, Mar 06, 2002 at 12:30:20PM -0500, Eric Webber wrote:
> >
> > I just now added a line which reads:
> >
> > host all 192.168.0.0 255.255.255.0 trust
> >
> > do I have to restart the server ?
>
> At least kill -HUP it - can always restart to be on the safe side..
>
> > I believe I compiled with ODBC support, but how do I check
> > for sure ?
>
> I don't think you need to compile in ODBC support - what you installed
> is on the windoze box, and it talks directly to the postmaster..
>
> BTW remember the -i flag..
>
> Patrick
>
>