Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cHzM5-0003Uz-5f for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Dec 2016 20:43:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cHzM4-0003eX-P1 for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Dec 2016 20:43:48 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cHzM3-0003do-HI for pgsql-hackers@postgresql.org; Fri, 16 Dec 2016 20:43:47 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cHzM1-0003nP-3e for pgsql-hackers@postgresql.org; Fri, 16 Dec 2016 20:43:46 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id B81D05F7B4; Fri, 16 Dec 2016 15:42:44 -0500 (EST) Date: Fri, 16 Dec 2016 15:42:44 -0500 From: Stephen Frost To: Peter Eisentraut Cc: Heikki Linnakangas , Michael Paquier , Robert Haas , Andres Freund , David Steele , Tom Lane , David Fetter , Alvaro Herrera , Magnus Hagander , Julian Markwort , PostgreSQL mailing lists , Valery Popov Subject: Re: pg_authid.rolpassword format (was Re: Password identifiers, protocol aging and SCRAM protocol) Message-ID: <20161216204244.GL18360@tamriel.snowman.net> References: <762f4875-a87e-cf0b-c06b-b357294d8be1@iki.fi> <2d07165c-1793-e243-a2a9-e45b624c7580@iki.fi> <20161214145723.GJ23417@tamriel.snowman.net> <9dc32483-b24a-5832-53e0-fb62838f1315@iki.fi> <20161215134030.GI23417@tamriel.snowman.net> <7a3e9184-9fca-3593-ffe2-729d15df32a6@2ndquadrant.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="sMkrXc3gAYLRVOjR" Content-Disposition: inline In-Reply-To: <7a3e9184-9fca-3593-ffe2-729d15df32a6@2ndquadrant.com> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 15:42:20 up 160 days, 22:06, 33 users, load average: 0.15, 0.12, 0.14 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -5.0 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --sMkrXc3gAYLRVOjR Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Peter Eisentraut (peter.eisentraut@2ndquadrant.com) wrote: > On 12/15/16 8:40 AM, Stephen Frost wrote: > > I don't follow why we can't change the syntax for CREATE USER to allow > > specifying the verifier type independently. >=20 > That's what the last patch set I looked at actually does. Well, same here, but it was quite a while ago and things have progressed since then wrt SCRAM, as I understand it... Thanks! Stephen --sMkrXc3gAYLRVOjR Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJYVFHEAAoJEO1sijiDR2RVczYQAKqKUtcpkE4AcPi/qIA0l488 yNSZYyB/bAxIqMUcs4nAIy1s0ptL6fOCHqFg0xzuqgqqBcA9IdRcdGCrRuUGDlk4 2p5cYoEZjqxBpRGBt1jN18HiuZQwWQr9U+TI7+a5ZZGGNV132MEqhAbJX6dLwExJ eP5gB/UmSYVPMkU/OnU8ejdXQ2eRjh4FbeKMpWJn1o8dFsASa3K8hf7xKr9fOosZ UvShn/iTHlqPofYTWWmlePlGoOfcfL82MTSVxvLIe+AHHqpz5k8T0VRx1VRmWBVN MeE2enMpRs+NSK75SRat2PQRQG1fagzABlIF8jKSSAHqZq48vKQPHSEZP9aXKdp/ 68j22B0XZg2cI5KlxC3XvkSVo4ArXK+/zuzfFmYoOyDAIXpJKWqiwg/NH7lZ//js BknLPx/dbqe37w+FfUIs+KfrviGwzIZg94jnBk2jdTll2DKNMWgmOsVRRtolVGNH 96wpQf8JfSXro/74EMBq4kM/naD0EcxwBYn124PXMwYEA7NjUm2dFEJVBcMj3lED jRbJiiofyPKNvcxoYApS7B3UXcQ2NfhhdEBmGC+NoqcfEvgydEw8EWvjV5AMVkgL yJeDNzVSR1vbNebrro0ohJTg2If0zIq/wcXIiVHztqYd35HOTi3hTQsWQYK3WFaA 7rmpR+rHcTP2Y1CoIo1s =6gyt -----END PGP SIGNATURE----- --sMkrXc3gAYLRVOjR--