Re: PATCH: warn about, and deprecate, clear text passwords

From: Roberto Mello <roberto(dot)mello(at)gmail(dot)com>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: Nathan Bossart <nathandbossart(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PATCH: warn about, and deprecate, clear text passwords
Date: 2025-03-16 15:04:12
Message-ID: CAKz==b+O406OTypVh7vQxYmdbV-utxq2=36=VNHDMf9nideG-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 14, 2025 at 12:50 PM Greg Sabino Mullane <htamfids(at)gmail(dot)com>
wrote:

> I'd rather not sit on this another year, if we can help it. We really
> should be warning people about this practice. The exact wording of the hint
> can be up for debate (or postponed - we technically don't have to say
> anything other than 'bad idea').
>
> Having the ability to disable clear text passwords seems an immediate win
> for those that want to enable it. Sure, we could be doing more, but I don't
> see any of the proposed future changes interfering with this patch.
>

I agree. This is a clear win that can easily be turned on by
packagers/distributors with little consequence to everyone else.

My only suggestion would be to have the GUC name be closer to other
password-related settings. Looking at the sample file I see

password_encryption
md5_password_warnings

So perhaps something like password_cleartext_action would fit in a little
better and make it easier to spot while going through the file.

Roberto

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shayon Mukherjee 2025-03-16 15:04:56 Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch)
Previous Message jian he 2025-03-16 13:49:58 Re: general purpose array_sort