Thread: 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 > >
> -----Original Message----- > From: Eric Webber [mailto:streethockey@ureach.com] > Sent: 06 March 2002 20:28 > To: Patrick Welche; pgsql-general@postgresql.org; > pgsql-odbc@postgresql.org > Subject: [ODBC] 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... Do you have any entries in the file _before_ this one that might reject your connection? The entries are tried sequentially, so the first match will be used. Regards, Dave.
[please keep replies on list] > -----Original Message----- > From: Eric Webber [mailto:streethockey@ureach.com] > Sent: 06 March 2002 21:50 > To: Dave Page > Subject: Re: RE: [ODBC] ODBC from win2k to postgres on Linux HELL > > > these are my enrties > > > > local all trust > host all 127.0.0.1 255.255.255.255 trust > host all 192.168.0.4 255.255.255.255 trust That looks OK. I did chat to one person recently who got in a mess because his linux distribution had come with an older version of PostgreSQL preinstalled, and unaware of this he had installed a new copy, but in a different location - end result was; he had 2 data directories (and was editting the wrong pg_hba.conf file) and 2 copies of the libraries and binaries etc. Could this be the case on your system? Regards, Dave.
Did you fix the problem? If not, 1) Which Linux distro do you use? 2) What is your PostgreSQL version? /Jean-Michel POURE