pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Jonathan S. Katz <jkatz@postgresql.org>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Add "password_protocol" connection parameter to libpq
Date: Fri, 9 Aug 2019 20:03:40 -0400
Message-ID: <20190810000340.GT16436@tamriel.snowman.net> (raw)
In-Reply-To: <a977da04af60668c487a7a21abbcbb87b9ea8344.camel@j-davis.com>
References: <227015d8417f2b4fef03f8966dbfa5cbcc4f44da.camel@j-davis.com>
	<20190809030021.GG3194@paquier.xyz>
	<3bbf5968ea705700a2605d6db74d8510bea7940b.camel@j-davis.com>
	<20190809100922.GI3194@paquier.xyz>
	<20190809132850.GL16436@tamriel.snowman.net>
	<609482826475e0063c7d71b2449ae31c0d61b232.camel@j-davis.com>
	<071e45a6-97f7-1614-371c-98ecb03aed65@postgresql.org>
	<dc2c84d5-92d3-acbc-4f39-2846d0c5a72d@iki.fi>
	<a977da04af60668c487a7a21abbcbb87b9ea8344.camel@j-davis.com>

Greetings,

* Jeff Davis (pgsql@j-davis.com) wrote:
> On Sat, 2019-08-10 at 00:17 +0300, Heikki Linnakangas wrote:
> > auth_methods = 'MITM, -password, -md5'
> 
> Keep in mind this is client configuration, so something reasonable in
> postgresql.conf might not be so reasonable in the form:

Yeah, that's a really good point.

> postgresql://foo:secret@myhost/mydb?auth_methods=MITM%2C%20-
> password%2C%20-md5
> 
> Another thing to consider is that there's less control configuring on
> the client than on the server. The server will send at most one
> authentication request based on its own rules, and all the client can
> do is either answer it, or disconnect. And the SSL stuff all happens
> before that, and won't use an authentication request message at all.

Note that GSSAPI Encryption works the same as SSL in this regard.

Thanks,

Stephen

Attachments:

  [application/pgp-signature] signature.asc (818B, ../20190810000340.GT16436@tamriel.snowman.net/2-signature.asc)
  download

view thread (46+ messages)  latest in thread

Message-ID: <20190810000340.GT16436@tamriel.snowman.net>
Permalink:  ../20190810000340.GT16436@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20190810000340.GT16436@tamriel.snowman.net

 · 

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-hackers@postgresql.org
  Cc: sfrost@snowman.net, pgsql@j-davis.com, hlinnaka@iki.fi, jkatz@postgresql.org, michael@paquier.xyz
  Subject: Re: Add "password_protocol" connection parameter to libpq
  In-Reply-To: <20190810000340.GT16436@tamriel.snowman.net>

* 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