Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,644 questions
Hi @tym ,
Sorry for the delay in my response. Was your issue resolved?
Data Factory PostgreSQL Error "Cannot load trust store"
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
tym
1
Reputation point
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?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 76%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChiragMishra-MSFT 956 Reputation points2020-06-04T10:05:54.59+00:00 Hi there,
Can you please share a screenshot of the error? That will help us to diagnose the issue faster.
-
tym 1 Reputation point
2020-06-04T14:41:34.31+00:00 
Here is the error screenshot
-
ChiragMishra-MSFT 956 Reputation points
2020-06-24T05:00:54.217+00:00 Hi Tym,
Sorry for the delayed response. Was the issue resolved?
-
ChiragMishra-MSFT 956 Reputation points
2020-06-24T05:01:17.973+00:00 Hi Tym,
Sorry for the delayed response. Was the issue resolved?
Sign in to comment
2 answers
Sort by: Most helpful
-
ChiragMishra-MSFT 956 Reputation points
2020-06-25T07:33:53.687+00:00 -
ChiragMishra-MSFT 956 Reputation points
2020-07-14T06:26:47.097+00:00 Hi @tym-8147,
Just wanted to check - was your issue resolved? Or do you need assistance?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 48%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RULS 1 Reputation point2021-07-01T09:12:21.22+00:00 Hello, I just run into the same issue, could you please assistant me?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 50%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
Warner Smith 1 Reputation point2021-09-28T14:54:24.643+00:00 Hello - Also hit this same error creating a PostgreSQL linked service using a self-hosted integration runtime with ValidateServerCertificate=1. Although the requester hasn't responded it would be helpful to update this post with official guidance on what's supported and what steps should be taken when this connection failure is encountered. If the solution is to turn off ValidateServerCertificate, it would be helpful to to have an explanation on how the risk of a ManInTheMiddle attack is mitigated. Thank you!
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 2%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI9%3C/text%3E%3C/svg%3E)
IsTra-9015 96 Reputation points2022-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