Re: Odd postgres12 upgrade is changing or munging a password? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Odd postgres12 upgrade is changing or munging a password?
Date
Msg-id 5d613e2e1b81500a868ceaa796fb901151b9cb15.camel@cybertec.at
Whole thread Raw
In response to Odd postgres12 upgrade is changing or munging a password?  (Tory M Blue <tmblue@gmail.com>)
Responses Re: Odd postgres12 upgrade is changing or munging a password?  (Tory M Blue <tmblue@gmail.com>)
List pgsql-general
On Thu, 2020-05-07 at 11:55 -0700, Tory M Blue wrote:
> Going from 9.5 to 12 and 2 times now, I've had a password either go missing or munged.
> I've had to add an alter statement at the end of the upgrade.
> 
> The DB is functioning fine, shut it down, do the upgrade and the password is munged.
> Seems like an odd occurrence, we have not noted any other weird issues.
> 
> Anyone else see or hear of this?

The only explanation I can come up with is that "password_encryption" is set to
"scram-sha-256" on the v12 server.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Memory footprint diff between 9.5 and 12
Next
From: Laurenz Albe
Date:
Subject: Re: pg_restore V12 fails consistently against piped pg_dumps