RE: pg_hba.conf

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'Jose Mercedes'" <jose_mercedes(at)usa(dot)net>, pgsql-odbc(at)postgresql(dot)org
Subject: RE: pg_hba.conf
Date: 2001-06-13 08:32:33
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F745DF@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,
it sounds as if you have different permissions in the pg_hba.conf
file. Is the NT machine also your server? If so then the pg_hba.conf file
has a default to trust the localhost and will therefore accept any valid
username (no need for password) IIRC. Something like the following line
would be the setting for allowing people to connect from any where with by
providing username and password:
host all 0.0.0.0 0.0.0.0 password
for more info see the pg_hba.conf file (and if editing on NT remeber that it
needs UNIX line termination (LF), pgsql-cygwin might be a good list if you
are using cygwin/NT to run PostgreSQL).
- Stuart

> -----Original Message-----
> From: Jose Mercedes [SMTP:jose_mercedes(at)usa(dot)net]
> Sent: Friday, June 08, 2001 5:58 PM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: pg_hba.conf
>
> I´m trying to get access to my PostgreSQL database from
> a NT workstation. The error message I Get says:
> "Unknow user name or password"
> "No pg_hba.conf entry for host xxxx, user xxxx, database xxxx"
>
> The best is that, this work from another NT workstations.
> So I think the problem is on my PC... but... What the problem is?
>
> Please, help me.
>
> Jose
>
>
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-06-13 08:38:02 Re: No dice trying to connect to an ODBC data source
Previous Message Hiroshi Inoue 2001-06-13 05:07:00 Re: ODBC 7.01.00.05 driver fails when text arrays are passed in asarguments to backend plpgsql functions