Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 8C2199FB619 for ; Wed, 2 May 2007 17:51:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 39402-06 for ; Wed, 2 May 2007 17:51:26 -0300 (ADT) X-Greylist: delayed 00:28:26.998926 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 848A39FB813 for ; Wed, 2 May 2007 17:51:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from sphere.lxrb.com (sphere.lxrb.com [38.112.190.22]) by svr4.postgresql.org (Postfix) with ESMTP id 37BC25AF043 for ; Wed, 2 May 2007 20:23:05 +0000 (GMT) Received: from 127.0.0.1 (localhost [127.0.0.1]) by sphere.lxrb.com (Postfix) with ESMTP id 87895A168 for ; Wed, 2 May 2007 16:22:51 -0400 (EDT) Subject: Multiple auth types for a connection From: Rob Cherry To: pgsql-admin@postgresql.org Content-Type: text/plain Message-Id: <1178137371.17100.6.camel@sphere.lxrb.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6.308 Date: Wed, 02 May 2007 16:22:51 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200705/28 X-Sequence-Number: 25348 Hi, I am operating in an environment where we have regular users who will authenticate via PAM and software users for automated processes that would be more appropriate to authenticate via a password (encrypted or not - irrelevant to this question). I have taken a look through the documentation and google and done some trial and error, but I dont seem to be able to get this working for a single client to be able to use either method. My 2 guesses involved changing the $PGDATA$/pg_hba.conf to try these options: 1: host all all 0.0.0.0/0 pam,password (also tried space seperated as well as comma seperated) 2: host all all 0.0.0.0/0 pam host all all 0.0.0.0/0 password In both cases (neither caused an error) the first type wins and the other gives access denied. Does anyone know if it is possible to overload auth types like this such that if pam fails password would be tried? Many thanks in advance, Rob Cherry