Is there still password max length restrictions in PG?

From: Sean <iihero(at)qq(dot)com>
To: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Is there still password max length restrictions in PG?
Date: 2024-03-18 13:29:11
Message-ID: tencent_0CACFEAEF59B4288FAE8B5F48299312E9907@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

Just noticed that the definition:
postgres=# \d pg_shadow
.....
&nbsp;usebypassrls | boolean&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |
&nbsp;passwd&nbsp; &nbsp; &nbsp; &nbsp;| text&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |
.....

Looks like there is no length restriction for the password of a user.

And in the code change history,&nbsp; 67a472d71c ("Remove arbitrary restrictions on password length.", 2020-09-03)&nbsp;
seems having removed the length restriction.&nbsp; (in the&nbsp; history,&nbsp; there is 100 or even max length of 1024.)

So,&nbsp; here,&nbsp; just a minor question,&nbsp; can we consider there is no max length restriction for the password of a user?　
Need some document to make a clarification or suggestion to the user?

BR,
Sean He (iihero(at)qq(dot)com)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michał Kłeczek 2024-03-18 13:31:41 Re: Alternative SAOP support for GiST
Previous Message Thomas Munro 2024-03-18 13:25:33 Re: Regression tests fail with musl libc because libpq.so can't be loaded