From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rob Cherry <postgresadmin@lxrb.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Multiple auth types for a connection
Date: Wed, 02 May 2007 17:42:38 -0400
Message-ID: <21650.1178142158@sss.pgh.pa.us> (raw)
In-Reply-To: <1178137371.17100.6.camel@sphere.lxrb.com>
References: <1178137371.17100.6.camel@sphere.lxrb.com>
Rob Cherry <postgresadmin@lxrb.com> writes:
> Does anyone know if it is possible to overload auth types like this such
> that if pam fails password would be tried?
No, it's not, as per the Fine Manual:
: The first record with a matching connection type, client address,
: requested database, and user name is used to perform
: authentication. There is no "fall-through" or "backup": if one record is
: chosen and the authentication fails, subsequent records are not
: considered. If no record matches, access is denied.
Your best bet is probably to list the automated users specifically in
a record that specifies password, and then put another record that
selects pam for everyone else.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, postgresadmin@lxrb.com
Subject: Re: Multiple auth types for a connection
In-Reply-To: <21650.1178142158@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox