Postgres 10 added support for a new password authentication mechanism, Salted Challenge Response Authentication Mechanism (SCRAM-SHA-256, see RFC 7677). Discussed by Michael Paquier.

➥ Can this mechanism work with JDBC drivers?

If not, why not?

If so, have any drivers yet implemented this feature?


I have not verified this myself, but the answer seems to be Yes, from version 42.2.0 of the driver from the jdbc.postgresql.org project.

To quote the changelog for Version 42.2.0:

Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library.

See GitHub pull request # 842.

That driver uses the SCRAM Java Implementation project by ongres.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.