Thread: cannot find pg_hba.conf file
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
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
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
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
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