Unable to Connect to Postgres Database

Question

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?

anonymous · Answer

Hi&nbsp; Anonymous&nbsp;,
&nbsp;
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
&nbsp;
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.

anonymous · Answer

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.

Forum Discussion

Unable to Connect to Postgres Database

2 Replies

Related content

Postgre connection

Database connectivity.

Connector Postgre SQL DATABASE

Connection to postgres Mac

Unable to connect MS Fabric and Azure database for Postgres using copy activity