| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Joe Conway <mail(at)joeconway(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: scram and \password |
| Date: | 2017-04-05 15:53:58 |
| Message-ID: | CA+TgmoYk+xfnvYC4xtQD4qFdu7xKn6bRLC-baH5MDdtyCSxg6w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Mar 25, 2017 at 1:10 AM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
> On Fri, Mar 24, 2017 at 10:12 PM, Heikki Linnakangas <hlinnaka(at)iki(dot)fi> wrote:
>> On 03/24/2017 03:02 PM, Michael Paquier wrote:
>>>
>>> In order to close this thread, I propose to reuse the patches I sent
>>> here to make scram_build_verifier() available to frontends:
>>>
>>> https://www.postgresql.org/message-id/CAB7nPqT4yc3u8wspYkWbG088Ndp6asMH3=Zb___Ck89CTvziYQ@mail.gmail.com
>>>
>>> And on top of it modify \password so as it generates a md5 verifier
>>> for pre-9.6 servers and a scram one for post-10 servers by looking at
>>> the backend version of the current connection. What do you think?
>>
>> Yep, sounds like a plan.
>
> And attached is a set of rebased patches, with createuser and psql's
> \password extended to do that.
Heikki, are you going to do something about these? We're running out of time.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2017-04-05 15:56:31 | Re: partitioned tables and contrib/sepgsql |
| Previous Message | Robert Haas | 2017-04-05 15:49:58 | Re: inconsistent page found on STANDBY server |