cannot find pg_hba.conf file

This is a multipart message in MIME format.

------=_NextPart_000_0032_01CA410B.6EC57340
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit


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





------=_NextPart_000_0032_01CA410B.6EC57340
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: cannot find pg_hba.conf file

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

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
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-c onf.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


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

On Tue, Sep 29, 2009 at 1:16 PM, Ramon Discua
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-c onf.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

Re: cannot find pg_hba.conf file

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
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-c onf.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


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