On 7th of March 2017, Heikki Linnakangas committed patch: Support SCRAM-SHA-256 authentication (RFC 5802 and 7677). This introduces a new generic SASL authentication method, similar to the GSS and SSPI methods. The server first tells the client which SASL authentication mechanism to use, and ...

As you perhaps know I'm fan of pgbouncer - connection pooling solution for PostgreSQL. It can do many really cool things, but has one slight issue. Since it can reuse connections - it has to provide a way to check if user ...

On 18th of November Tom Lane committed patch by Laurenz Albe which adds very interesting capability: Add a hook to CREATE/ALTER ROLE to allow an external module to check the strength of database passwords, and create a sample implementation of such a hook ...

Let's say you're in situation when you have to connect to PostgreSQL, but you have no idea on what password might be set. But some definitely is, as you get this error message: => psql Password: psql: FATAL: password authentication failed for ...