Thread: pg_hba.conf

pg_hba.conf

From
Jose Mercedes
Date:
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

RE: pg_hba.conf

From
"Henshall, Stuart - WCP"
Date:
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@usa.net]
> Sent:    Friday, June 08, 2001 5:58 PM
> To:    pgsql-odbc@postgresql.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