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 DB6FCD1E3DC for ; Sat, 24 Jan 2004 18:25:51 +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 04013-06 for ; Sat, 24 Jan 2004 14:25:27 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 605D2D1E3DD for ; Sat, 24 Jan 2004 14:25:20 -0400 (AST) Received: (qmail 2659 invoked by uid 500); 24 Jan 2004 18:26:31 -0000 Date: Sat, 24 Jan 2004 12:26:31 -0600 From: Bruno Wolff III To: Robert Cc: pgsql-admin@postgresql.org Subject: Re: Easy pg_hba.conf question. Message-ID: <20040124182631.GA2580@wolff.to> Mail-Followup-To: Robert , pgsql-admin@postgresql.org References: <4012AA20.8080807@scs.carleton.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4012AA20.8080807@scs.carleton.ca> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/187 X-Sequence-Number: 12050 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.