On 5/8/20 12:11 PM, Tory M Blue wrote:
On Thu, May 7, 2020 at 11:41 PM Laurenz Albe <laurenz.a...@cybertec.at
<mailto:laurenz.a...@cybertec.at>> wrote:
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
If that was the case, wouldn't it change the others as well? Why a
single password.
I would first confirm what password_encryption in postgresql.conf is set
to. By default it is set to 'md5'.
Super strange indeed :)
Tory
--
Adrian Klaver
adrian.kla...@aklaver.com
