Re: pg_upgrade: warn about roles with md5 passwords

On Wed, Jun 04, 2025 at 04:46:52PM -0400, Bruce Momjian wrote:
> On Wed, Jun 4, 2025 at 10:15:49PM +0200, Peter Eisentraut wrote:
>> I tend think pg_upgrade should stick to checking things that are necessary
>> for the upgrade to succeed. It shouldn't start being an interactive portal
>> to the release notes for aspects that are merely recommendations. I'm not
>> necessarily against having such a facility somewhere. But not everyone uses
>> pg_upgrade, and not every user of pg_upgrade reads all the messages.
>
> Yes, combine that with the fact that most people don't see pg_upgrade
> output, and the case is even less positive.

Okay, I'm getting the feeling that we should leave things as-is for v18 and
revisit 0002 (warning every time someone logs in with an MD5 password) down
the road. When we do remove MD5 password support, pg_upgrade will need
this check, but that's probably a few releases away still.

--
nathan