Thread: cannot find pg_hba.conf file

cannot find pg_hba.conf file

From
"Ramon Discua"
Date:

Hi, I am new to Postgres, so if the question is to basic I apologize. I am trying to migrate from SqlBase to Postgres.

I am trying to connect a windows XP station to a Postgres database on a Server machine. I installed the psqlodbc-08.04.0100-1 on the workstation and configure it with the server,  database, user and password, 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. The psqlOBDC setup did not create this file. Where can I find this file in a Windows workstation , so I can add the entry and the ODBC driver can read it ?  The only postgres installation done in the workstation is the ODBC driver.

Can anybody help me

Thanks in advance

 

Re: cannot find pg_hba.conf file

From
Richard Broersma
Date:
On Tue, Sep 29, 2009 at 12:47 PM, Ramon Discua
<rdiscua@rdscorporacion.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

Re: cannot find pg_hba.conf file

From
"Ramon Discua"
Date:
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@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Richard Broersma
Sent: Tuesday, September 29, 2009 1:56 PM
To: Ramon Discua
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] cannot find pg_hba.conf file

On Tue, Sep 29, 2009 at 12:47 PM, Ramon Discua
<rdiscua@rdscorporacion.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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc


Re: cannot find pg_hba.conf file

From
Richard Broersma
Date:
On Tue, Sep 29, 2009 at 1:16 PM, Ramon Discua
<rdiscua@rdscorporacion.com> wrote:

>  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?


Actually you don't need to put an entry for each users ip.  The
pg_hba.conf allows you to accept a range of IP address that your users
client computers are assigned.

The quickest way to properly configure your pg_hba.conf file would be
to spend about ten minutes reading the online documentation:

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

Also notice the examples under Example 19-1. Example pg_hba.conf entries.

Reply back with any problems that you encounter after trying some of
the examples.  A focused question is much more easy answer than
general one.


--
Regards,
Richard Broersma Jr.

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

Re: cannot find pg_hba.conf file

From
"Ramon Discua"
Date:
Again Thanks for the tip!

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

On Tue, Sep 29, 2009 at 1:16 PM, Ramon Discua
<rdiscua@rdscorporacion.com> wrote:

>  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?


Actually you don't need to put an entry for each users ip.  The
pg_hba.conf allows you to accept a range of IP address that your users
client computers are assigned.

The quickest way to properly configure your pg_hba.conf file would be
to spend about ten minutes reading the online documentation:

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

Also notice the examples under Example 19-1. Example pg_hba.conf entries.

Reply back with any problems that you encounter after trying some of
the examples.  A focused question is much more easy answer than
general one.


--
Regards,
Richard Broersma Jr.

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc