X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E6F19D9C8A for ; Thu, 29 Sep 2005 18:01:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60440-09 for ; Thu, 29 Sep 2005 21:01:32 +0000 (GMT) Received: from smtp.iceenterprise.com (smtp.iceenterprise.com [12.152.67.110]) by svr1.postgresql.org (Postfix) with ESMTP id B0E3ED9C7B for ; Thu, 29 Sep 2005 18:01:32 -0300 (ADT) Received: from newman.iceenterprise.com ([10.2.10.32]) by smtp.iceenterprise.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 29 Sep 2005 14:05:18 -0700 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C539.7E88AB30" Subject: pg_hba.conf setup Date: Thu, 29 Sep 2005 14:00:49 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: pg_hba.conf setup Thread-Index: AcXFON50FR8JJ735TkWB66HgORFgoQ== From: "Ben Sullins" To: X-OriginalArrivalTime: 29 Sep 2005 21:05:18.0146 (UTC) FILETIME=[7ED28220:01C5C539] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.881 required=5 tests=[AWL=0.880, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/9 X-Sequence-Number: 19081 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5C539.7E88AB30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Greetings, =20 I am attempting to setup a DTS package in Sql Server that will copy over data from a Postgres database. I have followed the instructions found here (http://techdocs.postgresql.org/techdocs/usingpostgresqlwithdotnet.php) but am still unable to connect. The error I receive when connecting is "No pg_hba.conf entry for host , user , database ".=20 =20 I logged onto the linux box via ssh and edited the file by adding a line in pg_hba.conf for my ip. I'm thinking it other lines above my new entry could be affecting my access restrictions. Below are the lines in order as they appear in pg_hba.conf. Any assistance will be most appreciated. ------- local all all ident sameuser host all all 127.0.0.1 255.255.255.255 md5 host 255.255.255.255 trust ------- Thanks, -- Ben Sullins Enterprise Reporting Team =20 ------_=_NextPart_001_01C5C539.7E88AB30 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Greetings,

 

I am attempting to setup a DTS package in Sql = Server that will copy over data from a Postgres database. I have followed the = instructions found here (http://techdocs.postgresql.org/techdocs/usingpostgresqlwithdotnet.p= hp) but am still unable to connect. The error I receive when connecting is = “No pg_hba.conf entry for host <myipaddy>, user <myuser>, = database <mydb>”.

 

I logged onto the linux box via ssh and edited the = file by adding a line in pg_hba.conf for my ip. I’m thinking it other = lines above my new entry could be affecting my access restrictions. Below are the = lines in order as they appear in pg_hba.conf. Any assistance will be most = appreciated.

-------

local  all      all           &nbs= p; ident   sameuser

host all all 127.0.0.1 255.255.255.255 = md5

host <myuser> <mydb> <myip> 255.255.255.255 trust

-------

Thanks,

--

Ben Sullins

Enterprise Reporting Team

 

------_=_NextPart_001_01C5C539.7E88AB30--