X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9378A3B7107 for ; Thu, 16 Dec 2004 17:10:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55097-09 for ; Thu, 16 Dec 2004 17:10:18 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 3B2FC3B70AE for ; Thu, 16 Dec 2004 17:10:17 +0000 (GMT) Received: (qmail 11716 invoked by uid 500); 16 Dec 2004 17:23:03 -0000 Date: Thu, 16 Dec 2004 11:23:03 -0600 From: Bruno Wolff III To: FM Cc: Mailing List Postgres-Admin Subject: Re: pg_hba and * Message-ID: <20041216172303.GB11300@wolff.to> Mail-Followup-To: FM , Mailing List Postgres-Admin References: <41C1AF3F.4080104@lexum.umontreal.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41C1AF3F.4080104@lexum.umontreal.ca> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/174 X-Sequence-Number: 15760 On Thu, Dec 16, 2004 at 10:52:31 -0500, FM wrote: > Hello, > We have kerberos auth for all humain users, but I still need md5 auth > for scripts users. > > All my scripts user name start with soft_ > > Can I add soft_* in the pg_hba ? You can't do pattern matching there. It probably wouldn't be that hard to make a custom change to allow some sort of pattern matching. Another option would be to have a script that updates pg_hba.conf as needed (and signal the server). Yet another possible option (if the scripts are only run from the server) is to use md5 for domain socket connections and kerberos for tcp/ip connections.