I have a MS .net application that needs to access a postgres database that's been recently upgraded to v13.
I'm using the
Npgsql library (very old version) and get the error Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10
The suggestion from this post is to comment-out the line password_encryption in the file postgresql.conf and then re-set the users passwords
ALTER USER ???? PASSWORD '1234'. I try this and get the same error, I also tried
ALTER USER ???? UNENCRYPTED PASSWORD '1234' but this option isn't available anymore.
The basic problem seems to be that postgres 13 wants a level of security that the
Npgsql library can't cope with. I can't upgrade
Npgsql (not my choice!), so unless I can downgrade the password requirements I'm going to have to regress to an earlier version of postgres
I've tried setting
password_encryption = scram-sha-256 also
password_encryption = md5 and I've tried commenting-out the whole line. Each time I make the change I run SELECT pg_reload_conf() (as per the comments in the file) and then reset the passwords before trying to log on again. Same error every time.
ok, just found a cure that will fix the immediate problem. I've edited the pg_hba.conf file (thanks @jjanes) and changed the METHOD from
md5. This seems to work.