Unable to Connect to Postgres Database

[kellyylt]

Hello everyone, I am trying to connect to Azure Postgresql and have tried several methods but still met with this error - Details: "An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'"

Here are some things that I'd tried:

- Imported DigiCertGlobalRootCA into Trusted Root Certification Authorities

- Imported BaltimoreCyberTrustRoot into Trusted Root Certification Authorities

- Installed npg sql 4.0.10 with GAC installation

I am able to connect via ODBC but the performance is pretty bad so I am thinking to test the Azure Postgresql connector but am not successful. Can anyone help me with this?

[v-yangliu-msft]

Hi  @kellyylt ,

Please check if the solution in the following thread can solve your problem.

Solved: The remote certificate is invalid according to the... - Microsoft Fabric Community

This is the related document, you can view this content:

Re: The remote certificate is invalid according to... - Microsoft Fabric Community

Solved: Invalid certificate 2020-07-13 - Microsoft Fabric Community

PostgreSQL Personal Gateway Data Source credential... - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kellyylt]

Hi Liu Yang, I have looked through the links. Unfortunately, some are not applicable and I have already tried what's been done for the connection to AWS Postgresql. It does not seem to work for the one on Azure Postgresql.