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

[Sean]

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


------------------ Original ------------------
From:                                                                           
                                             "Daniel Gustafsson"                
                                                                    
<dan...@yesql.se&gt;;
Date:&nbsp;Mon, Mar 18, 2024 09:49 PM
To:&nbsp;"Sean"<iih...@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 <iih...@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