Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 2E309632359 for ; Thu, 15 Jan 2009 13:35:34 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28596-01-4 for ; Thu, 15 Jan 2009 13:35:27 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id 0C4FE632393 for ; Thu, 15 Jan 2009 13:34:49 -0400 (AST) Received: (qmail invoked by alias); 15 Jan 2009 17:34:45 -0000 Received: from dslb-082-083-050-095.pools.arcor-ip.net (EHLO [192.168.123.148]) [82.83.50.95] by mail.gmx.net (mp007) with SMTP; 15 Jan 2009 18:34:45 +0100 X-Authenticated: #955937 X-Provags-ID: V01U2FsdGVkX18q3zJL2OIqa0pDEOeGVLDJl3vf+doCnYcpGzzRvG z1pGQ6JisyDbly Message-ID: <496F73A6.7010202@gmx.de> Date: Thu, 15 Jan 2009 18:34:30 +0100 From: Jan-Peter Seifert User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Andreas Wenk CC: pgsql-admin@postgresql.org Subject: Re: MD5 password issue References: <496F4627.9040408@netzmeister-st-pauli.de> In-Reply-To: <496F4627.9040408@netzmeister-st-pauli.de> Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.6 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/49 X-Sequence-Number: 31096 Andreas Wenk wrote: > In pg_hba.conf we have: > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > > # "local" is for Unix domain socket connections only > local all all ident sameuser > > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > host all all 192.168.97.0/24 md5 > > Now the question: why is the user pgadmin able to connect to the database using pgAdmin > III from 192.168.97.30? That sould not be possible ... or am I wrong? Maybe you did save the login informationen in pgAdmin on 192.168.97.30 once? http://www.pgadmin.org/docs/1.4/pg/libpq-pgpass.html Peter