topic Problems Encryption Method during version change - Postgres 9.6 in Management & Governance

Problems Encryption Method during version change - Postgres 9.6

robb183 — Tue, 05 Jul 2022 09:27:20 GMT

During the version upgrade from Qlik Sense November 2019 to February 2022 the attached message appeared in the environment multinode.

Has anyone got the same message? Tips?

thank you

Roberto

Re: Problems Encryption Method during version change - Postgres 9.6

Eugene_Sleator — Tue, 05 Jul 2022 14:12:45 GMT

Hi @robb183 have you changed the encryption type, or enabled database traffic encryption? See this article.

Re: Problems Encryption Method during version change - Postgres 9.6

Albert_Candelario — Tue, 05 Jul 2022 20:18:37 GMT

Hello @robb183 ,

Thanks for posting.

Kindly go to the file mentioned and check the method used and if is using one of the mentioned ones as below:

# TYPE DATABASE USER ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5

If is not the case, kindly edit it and try to upgrade again and afterwards (once the upgrade is successful) change it back to the current method.

Cheers,

Albert