How can I solve Postgresql SCRAM authentication problem?
Jul 9
I am getting an error after moving the project to production. The error is as follows while running with production server
pg_connect(): Unable to connect to PostgreSQL server: SCRAM authentication requires libpq version 10 or above.
Here is my PostgreSQL version:
Development Version :
PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
Production Version :
PostgreSQL 11.5 (EnterpriseDB Advanced Server 11.5.12) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
postgresql1 answer
Accepted answer · original discussion
Jul 9
Your application uses an API that is linked with the PostgreSQL client C library libpq.
The version of that library must be 9.6 or older, and SCRAM authentication was introduced in v10.
Upgrade libpq on the application end and try again.
If you don't need scram-sha-256 authentication, you can revert to md5:
- set
password_encryption = md5inpostgresql.conf - change the authentication method to
md5inpg_hba.conf - reload PostgreSQL
- change the password of the user to get an MD5 encrypted password
Your perspective belongs here.
3 question comments
Use comments to ask for clarification. Post a solution as an answer.
Jul 9
Jul 9