Re: Is there still password max length restrictions in PG?

Sean <iihero@qq.com>

From: Sean <iihero@qq.com>

To: Daniel Gustafsson <daniel@yesql.se>

Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>

Date: 2024-03-18T13:51:27Z

Lists: pgsql-hackers

Thanks Daniel.&nbsp;&nbsp;
That's a big help to me!


------------------&nbsp;Original&nbsp;------------------
From:                                                                                                                        "Daniel Gustafsson"                                                                                    <daniel@yesql.se&gt;;
Date:&nbsp;Mon, Mar 18, 2024 09:49 PM
To:&nbsp;"Sean"<iihero@qq.com&gt;;
Cc:&nbsp;"pgsql-hackers"<pgsql-hackers@lists.postgresql.org&gt;;
Subject:&nbsp;Re: Is there still password max length restrictions in PG?



&gt; On 18 Mar 2024, at 14:43, Sean <iihero@qq.com&gt; wrote:
&gt; 
&gt; Hi, 
&gt; Thanks for your information.&nbsp; Even using SCRAM,&nbsp; when specified the content of "password",&nbsp; still there is a basic request about the length of it.&nbsp; From the source code, seems there is no restriction, right?　

SCRAM stores a hashed fixed-size representation of the password, so there is no
restriction in terms of length on the user supplied secret.

--
Daniel Gustafsson