Relative Content

Tag Archive for postgresqlsha256

How does scram-sha-256 authentication in postgresql?

If I use a tool like https://denismedeiros.github.io/scram-sha-256-generator/ and use it to generate a hash and then create a user with its value as the password, when logging into the user, how does the PostgreSQL cluster/client generate a new hash that it is authenticated. The clientproof, clientkey and storedkey differ from what’s on the PostgreSQL cluster, so how is it auth’ing?