pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Geoff Tolley <geoff@polimetrix.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Rob Cherry <postgresadmin@lxrb.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Multiple auth types for a connection
Date: Wed, 02 May 2007 15:13:11 -0700
Message-ID: <46390CF7.2040200@polimetrix.com> (raw)
In-Reply-To: <21650.1178142158@sss.pgh.pa.us>
References: <1178137371.17100.6.camel@sphere.lxrb.com>
	<21650.1178142158@sss.pgh.pa.us>

Tom Lane wrote:
> 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:

Provided that you don't care about the security and performance 
implications of SSL vs non-SSL connectivity, wouldn't it be possible to 
have something like:

hostnossl    all         all         0.0.0.0/0             krb5
hostssl      all         all         0.0.0.0/0             md5

... and then have sslmode set to prefer or allow on the client side?

Cheers,
Geoff



view thread (3+ messages)

Message-ID: <46390CF7.2040200@polimetrix.com>
Permalink:  ../46390CF7.2040200@polimetrix.com/
Also on:    postgresql.org/message-id/46390CF7.2040200@polimetrix.com

 · 

reply

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: geoff@polimetrix.com, tgl@sss.pgh.pa.us, postgresadmin@lxrb.com
  Subject: Re: Multiple auth types for a connection
  In-Reply-To: <46390CF7.2040200@polimetrix.com>

* 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