debops icon indicating copy to clipboard operation
debops copied to clipboard

postgres role - version 14 of pg introduced breaking change in password_encryption

Open ser opened this issue 3 years ago • 0 comments

before version 14:

password_encryption = on

in 14: Available values: md5, scram-sha-256

so the role must distinguish between versions and in new version probably use scram-sha-256 as default with an option to move back to md5

password_encryption = scram-sha-256

the most annoying thing is that with password_encryption = on version 14 does not start giving an error.

ser avatar Apr 26 '22 18:04 ser