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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
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">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
[at] font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
h1
{mso-style-priority:9;
mso-style-link:"Heading 1 Char";
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:24.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.Heading1Char
{mso-style-name:"Heading 1 Char";
mso-style-priority:9;
mso-style-link:"Heading 1";
font-family:"Times New Roman","serif";
font-weight:bold;}
..MsoChpDefault
{mso-style-type:export-only;}
[at] page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<h1><span style=3D'font-size:12.0pt;font-weight:normal'>Hi, I am new to =
Postgres,
so if the question is to basic I apologize. I am trying to migrate from =
SqlBase
to Postgres.<o:p></o:p></span></h1>

<h1><span style=3D'font-size:12.0pt;font-weight:normal'>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.<o:p></o:p></span></h1>

<h1><span style=3D'font-size:12.0pt;font-weight:normal'>Can anybody help =
me <o:p></o:p></span></h1>

<h1><span style=3D'font-size:12.0pt;font-weight:normal'>Thanks in =
advance<o:p></o:p></span></h1>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

</body>

</html>

------=_NextPart_000_0032_01CA410B.6EC57340--
Ramon Discua [ Di, 29 September 2009 21:47 ] [ ID #2017427 ]

Re: cannot find pg_hba.conf file

On Tue, Sep 29, 2009 at 12:47 PM, Ramon Discua
<rdiscua [at] 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-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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Richard Broersma [ Di, 29 September 2009 21:55 ] [ ID #2017428 ]

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

On Tue, Sep 29, 2009 at 12:47 PM, Ramon Discua
<rdiscua [at] 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-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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Ramon Discua [ Di, 29 September 2009 22:16 ] [ ID #2017429 ]

Re: cannot find pg_hba.conf file

On Tue, Sep 29, 2009 at 1:16 PM, Ramon Discua
<rdiscua [at] 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-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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Richard Broersma [ Di, 29 September 2009 22:32 ] [ ID #2017431 ]

Re: cannot find pg_hba.conf file

Again Thanks for the tip!

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

On Tue, Sep 29, 2009 at 1:16 PM, Ramon Discua
<rdiscua [at] 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-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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc


--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Ramon Discua [ Di, 29 September 2009 22:35 ] [ ID #2017432 ]
Datenbanken » gmane.comp.db.postgresql.odbc » cannot find pg_hba.conf file

Vorheriges Thema: sqlDescribeCol not setting null flag correctly for sqlDescribeCol
Nächstes Thema: ODBC( true = -1) and MS-Access