X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 51E979DC84E for ; Tue, 14 Feb 2006 23:52:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 52577-09 for ; Tue, 14 Feb 2006 23:52:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from post5.inre.asu.edu (post5.inre.asu.edu [129.219.110.120]) by postgresql.org (Postfix) with ESMTP id C1BBC9DC81F for ; Tue, 14 Feb 2006 23:21:06 -0400 (AST) Received: from conversion.post5.inre.asu.edu by asu.edu (PMDF V6.1-1X6 #30769) id <0IUP00C01L2Y3L@asu.edu> for pgsql-admin@postgresql.org; Tue, 14 Feb 2006 20:16:10 -0700 (MST) Received: from smtp.asu.edu (smtp.asu.edu [129.219.110.107]) by asu.edu (PMDF V6.1-1X6 #30769) with ESMTP id <0IUP00B60L2YO0@asu.edu> for pgsql-admin@postgresql.org; Tue, 14 Feb 2006 20:16:10 -0700 (MST) Received: from teancum.pp.asu.edu (teancum.pp.asu.edu [129.219.69.212]) by smtp.asu.edu (8.12.10/8.12.10/asu_smtp_relay, nullclient, tcp_wrapped) with ESMTP id k1F3G9j5002344 for ; Tue, 14 Feb 2006 20:16:09 -0700 (MST) Received: by teancum.pp.asu.edu (Postfix, from userid 1000) id 194D3E95; Tue, 14 Feb 2006 20:16:05 -0700 (MST) Date: Tue, 14 Feb 2006 20:16:05 -0700 From: David Bear Subject: hba conf ident sameuser not working To: pgsql-admin@postgresql.org Reply-to: David.Bear@asu.edu Message-id: <20060215031605.GH14507@asu.edu> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-disposition: inline User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.181 required=5 tests=[AWL=0.180, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.181 X-Spam-Level: X-Archive-Number: 200602/184 X-Sequence-Number: 20605 I am using auth method of 'ident sameuser' on a postgresql 8 server. ALL connections to postgres must come from localhost or local unix socket. now, when I connection to postgres from remote machines I ssh into the pg server, but I tunnel postgres traffic. The ident sameuser prevents tunneled connections from working. is there any workaround? -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"