The FOLIO project does not use PostgreSQL 9.x any longer. It has already upgraded to PostgreSQL 10.

I cannot find any usage of PostgreSQL 9.x, therefore I close this issues as "cannot reproduce".

The bug reports about SSL/TLS and SCRAM-SHA-256 are not caused by PostgreSQL 9.x. They already got dedicated issues: https://folio-org.atlassian.net/browse/FOLIO-2411#icft=FOLIO-2411, https://folio-org.atlassian.net/browse/FOLIO-2412#icft=FOLIO-2412, https://folio-org.atlassian.net/browse/OKAPI-787#icft=OKAPI-787

As I'm a SysOp and not a Dev, I look at Folio as a black box system and just try stuff with it. Since Okapi (2.36.0) was not able to work with SSL and SCRAM-SHA-256, the latter of which was introduced with PG 10, it has to either work on a prior version or was stripped to the bones by devs (which would be asking for cattle prod sessions all the way).

So yes, I'm technically able to try to force all modules to talk to my Debian 10 PostgreSQL server via SSL using SCRAM-SHA-256 passwords, but I'm only able to provide hints (i. e. works or not). For me things just have to work in a bullet proof way, that is safe to use and secure in depth.

@Johannes Drexl Can you give a more detailed report where FOLIO still uses PostgreSQL 9.x? Please post URLs to the affected documentation/script/installation.

RAML Module Builder (RMB) has switched from 9.6 to 10 in April 2018:
https://github.com/folio-org/raml-module-builder/commit/ac59e211b0323992092bcb6ef177c7c46aacf79b#diff-04c6e90faac2675aa89e2176d2eec7d8R986

The reference environments ( https://dev.folio.org/guides/automation/#reference-environments ) have switched from 9.6 to 10 in April 2019: https://github.com/folio-org/folio-ansible/commit/d2445aaa87fe03aee36a3e63cbd18d53577ee02c

The single server installation documentation has switched from 9.6 to 10 in Juni 2019: https://github.com/folio-org/folio-install/commit/665f5395e21b65f626f24fc55ca873e4586ec748

This is a branch of https://folio-org.atlassian.net/browse/FOLIO-2406