Re: cannot find pg_hba.conf file

Thanks, know I understand the entry has to be added to server side not on
the client side. However this means that every time I add a user, that uses
my application from a different workstation I have to add the entry to the
pg_hba file on the server side? Is there a way to avoid this?
Thanks for your prompt response

Ramon

-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Richard Broersma
Sent: Tuesday, September 29, 2009 1:56 PM
To: Ramon Discua
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] cannot find pg_hba.conf file

On Tue, Sep 29, 2009 at 12:47 PM, Ramon Discua
<rdiscua(at)rdscorporacion(dot)com> wrote:

> but when I test
> the connection I get "FATAL: no pg_hba.conf entry for host...". However I
> can not find this file to add the entry.

Actually this file is located on the computer that PostgreSQL is
running on. The PostgreSQL server uses this file to determine it will
accept connections from a client host.

here is information about the file:

http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-conf.html

On my computer it is located here:

Directory of C:\Program Files\PostgreSQL\8.4\data

07/28/2009 01:16 PM 3,425 pg_hba.conf
1 File(s) 3,425 bytes
0 Dir(s) 14,203,064,320 bytes free

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug