Support Postgres 14 and SCRAM by upgrading to libpq version 10 or above.
dlydiard opened this issue · 4 comments
The POD system-app-1-hook-pre fails to run successfully when using an external postgres database on version 14.5.
The logs report the following error:
PG::ConnectionBad: SCRAM authentication requires libpq version 10 or above
as a workaround i set the default password_encryption to md5 on the postgres cluster and changed the ROLE passwords, and system-app-1-hook-pre ran successfully.
Please support SCRAM authentication as it's a more secure auth method, thanks!
The 3scale operator can be anhanced to deploy (not recommended for production) Postgresql 14. Currently (2.13) the supported version is PostgreSQL 13 (From https://access.redhat.com/articles/279852)
But first, the Porta component (aka System) needs to support PostgreSQL 14. This issue is all about Porta supporting Postgresql 14, thus I think it should be opened in https://github.com/3scale/porta.
doesn't look like the Porta repo takes issues (at least for me).
You should then open a jira issue and set System as the Component
Thanks, issue opened: https://issues.redhat.com/browse/THREESCALE-9706