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

2024-03-18 Thread Sean
Thanks Daniel.   That's a big help to me! -- Original -- From: "Daniel Gustafsson"

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

2024-03-18 Thread Daniel Gustafsson
> On 18 Mar 2024, at 14:43, Sean 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-si

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

2024-03-18 Thread Sean
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??? Is it reasonable??? BR, Sean He -- Original --

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

2024-03-18 Thread Daniel Gustafsson
> On 18 Mar 2024, at 14:29, Sean wrote: > Need some document to make a clarification or suggestion to the user? The suggestion is to not use password authentication but instead use SCRAM. -- Daniel Gustafsson

Is there still password max length restrictions in PG?

2024-03-18 Thread Sean
Hi All, Just noticed that the definition: postgres=# \d pg_shadow .  usebypassrls | boolean                  |           |          |  passwd       | text                     | C         |          | . Looks like there is no length restriction for the password of a user. And in the