Horton

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

Daniel Gustafsson <daniel@yesql.se>

View thread
From: Daniel Gustafsson <daniel@yesql.se>
To: Sean <iihero@qq.com>
Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-03-18T13:49:58Z
Lists: pgsql-hackers 
> On 18 Mar 2024, at 14:43, Sean <iihero@qq.com> wrote:
> 
> Hi, 
> Thanks for your information.  Even using SCRAM,  when specified the content of "password",  still there is a basic request about the length of it.  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