Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8298A9FBBE6 for ; Thu, 26 Jul 2007 03:46:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 28404-01 for ; Thu, 26 Jul 2007 03:46:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from aa002msb.fastweb.it (aa002msb.fastweb.it [85.18.95.81]) by postgresql.org (Postfix) with ESMTP id 30C3C9FB9C7 for ; Thu, 26 Jul 2007 03:46:53 -0300 (ADT) Received: from fluca (85.18.239.131) by aa002msb.fastweb.it (7.3.118.6) id 46657813025548E3 for pgsql-general@postgresql.org; Thu, 26 Jul 2007 08:46:49 +0200 From: Luca Ferrari To: pgsql-general@postgresql.org Subject: Re: granting acces to an external client Date: Thu, 26 Jul 2007 08:33:22 +0200 User-Agent: KMail/1.9.7 References: <20070725101447.BFD908E40FC@mailhost.ics.forth.gr> In-Reply-To: <20070725101447.BFD908E40FC@mailhost.ics.forth.gr> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200707260833.23358.fluca1978@infinito.it> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/1062 X-Sequence-Number: 117663 On Wednesday 25 July 2007 Sorin N. Ciolofan's cat, walking on the keyboard, wrote: > Hello! > > I'd like to ask you what line should be added in pg_hba.conf file in order > to grant access to a user with ip > 139.100.99.98 to a db named "myDB" with user "scott" with password > "mikepwd"? > This should work: host myDB scott 139.100.99.98 md5 For the password you must use the $HOME/.pgpass file storing a line like the following: dbHost:5432:myDB:scott:mikepwd being dbHost the host that is running postgres. After that issue a reload. Hope this helps. Luca