Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 126229FB7E7 for ; Mon, 5 Mar 2007 20:02:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 73969-01 for ; Mon, 5 Mar 2007 20:02:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cooma-1.andyshellam.eu (cooma-1.andyshellam.eu [82.165.38.62]) by postgresql.org (Postfix) with ESMTP id AD0DF9FB438 for ; Mon, 5 Mar 2007 20:02:28 -0400 (AST) Received: from user-3e88ba12.telcl18.dsl.pol.co.uk ([62.136.186.18]:3599 helo=[10.100.9.2]) by cooma-1.andyshellam.eu with esmtpa (Exim 4.66) (envelope-from ) id 1HONB8-0001fg-2r; Tue, 06 Mar 2007 00:05:18 +0000 Message-ID: <45ECAF92.1000307@mailnetwork.co.uk> Date: Tue, 06 Mar 2007 00:02:26 +0000 From: Andy Shellam Reply-To: andy.shellam-lists@mailnetwork.co.uk Organization: www.AndyShellam.EU User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Moritz Bayer CC: pgsql-admin@postgresql.org Subject: Re: pg_hba.conf & putty References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.332 tagged_above=0 required=5 tests=AWL, BAYES_50, NORMAL_HTTP_TO_IP, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/17 X-Sequence-Number: 24841 What address are you using for "server.ip.address"? I believe this is the address you should put in your pg_hba.conf, not 127.0.0.1. Then in PgAdmin, connect to localhost:5432. You can always check your PostgreSQL logs and see what source address the request is coming from. Andy. Moritz Bayer wrote: > dear list, > > I know there are already hunderts of posts about pg_hba.conf, but > still after reading a few of them I still got troubles with this topic. > > I've got a vpn server with a ststic ip address, java apps are > supposed to run there receiving data from a postgresql database. > The database is running, but for changes on it I want to open a putty > connection while using pgAdmin. > In putty, I define a tunnel to port 5432, its displayed like this: > Lserver.ip.address:5432 > > Thought this entries in my pg_hba.conf would do it: > > # "local" is for Unix domain socket connections only > local all all md5 > > # IPv4 local connections: > host all all 127.0.0.1/32 > md5 > > # IPv6 local connections: > host all all ::1/128 md5 > > well, it doesn't. When i run pgAdmin with an open putty connection, > it still says: error connecting to server. > > Any hints how I can find out whats still wrong? > > Thanks in advance, > Mo > !DSPAM:37,45ecaa2b103007769414910!