X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id CABAED1E815 for ; Sat, 24 Jan 2004 19:19:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 13217-04 for ; Sat, 24 Jan 2004 15:18:49 -0400 (AST) Received: from connectmail.carleton.ca (connectmail.carleton.ca [134.117.2.12]) by svr1.postgresql.org (Postfix) with ESMTP id DF6F4D1D2DC for ; Sat, 24 Jan 2004 15:18:42 -0400 (AST) Received: from scs.carleton.ca (CPE0007952ccfc8-CM014160002607.cpe.net.cable.rogers.com [24.157.220.233]) by connectmail.carleton.ca (iPlanet Messaging Server 5.2 HotFix 1.21 (built Sep 8 2003)) with ESMTPSA id <0HS000J4TDN1EY@connectmail.carleton.ca> for pgsql-admin@postgresql.org; Sat, 24 Jan 2004 14:18:39 -0500 (EST) Date: Sat, 24 Jan 2004 14:18:09 -0500 From: Robert Subject: Re: Easy pg_hba.conf question. In-reply-to: <20040124182631.GA2580@wolff.to> To: Bruno Wolff III Cc: pgsql-admin@postgresql.org Message-id: <4012C4F1.4010706@scs.carleton.ca> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031007 References: <4012AA20.8080807@scs.carleton.ca> <20040124182631.GA2580@wolff.to> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/188 X-Sequence-Number: 12051 Bruno Wolff III wrote: >On Sat, Jan 24, 2004 at 12:23:44 -0500, > Robert wrote: > > >>I want to add a line in a pg_hba.conf file so that the user 'auser' can >>connect to the database 'aDB' via host based authentication: so far for >>the line I have: >> >>host aDB 134.117.76.10 255.255.255.255 md5 >> >> >>However, I'm not sure how to specify only 'auser' can connect to the >>database. >> >> > >What version of postgres are you using? I think the hba format changed >between 7.1 and 7.2 (though it might have been between 7.2 and 7.3) >to include a specifation for allowed users. > > I'm using 7.2, the one shipped with Debian Stable/3.0.