Data Factory PostgreSQL Error "Cannot load trust store"

tym 1 Reputation point
2020-06-03T22:46:59.497+00:00

I am trying to make a Copy Data connection to an external (IBM bare-metal) PostgreSQL server with SSL encryption. I have verified the certificate over ODBC locally, but keep getting "Cannot load trust store" error from the ADF PostgreSQL connector if I try to set the connection to Validate server certificate. I don't see a way to set TrustStore parameters in the interface, and wouldn't know what they need to be set to in order to avoid the error. Has anyone else run into this and found a solution?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,153 questions
{count} votes

2 answers

Sort by: Most helpful
  1. ChiragMishra-MSFT 956 Reputation points
    2020-06-25T07:33:53.687+00:00

    Hi @tym ,

    Sorry for the delay in my response. Was your issue resolved?


  2. IsTra-9015 96 Reputation points
    2022-03-11T18:57:03.087+00:00

    Solution is to use PostgreSQL ODBC drivers on your machine
    Steps and full details are found here: https://azuretechhelp.blogspot.com/2019/05/steps-to-connect-postgresql-to-azure.html

    0 comments No comments