Postgre "Remote certificate invalid according to the validation procedure"
I am trying to connect to a postgresql database using powerbi desktop and getting the message outlined in the title. I have received and imported root certificate into local user's trusted root certificates store. I have set certificate revocation check to "none". Neither did help and I'm still getting the aforementioned error message. I've enabled trace logging in hopes of finding information about certificate being presented by posgresql - but it's not being logged anywhere, rendering this tracing useless. Similar threads result in suggestions to install third-party packages for postgre. Then, why there's even a built-in option for PosgreSQL connection when it doesn't work from the box and requires third-party stuff? Questions: - why is option to never validate certificates being ignored by the app? - why importing root ca's certificate referring to the postgre certificate didn't solve the issue about supposedly untrusted certificate? - is there any way to get information about specific certificate, through trace logging or otherwise?