Share via

Impossible to connect to a distant postgresql database

Mathias Broutin 1 Reputation point
2020-07-30T12:19:44.963+00:00

Hello,

I want to use Power Bi in order to make a naturalist app with our postgresql database. I use this database on my computer with different softwares.
I installed Npgsql-4.0.10 first as recommended.
When I try to connect to my database, I got the following message (in french) :

"Connexion impossible

Nous avons rencontré une erreur lors de la tentative de connexion.

Détails : « Une erreur s'est produite pendant la lecture des données du fournisseur : 'Le certificat distant n'est pas valide selon la procédure de validation.' »"

Which means :

"Unable to connect

We encountered an error while trying to connect.

Details: "An error occurred while reading the provider data: 'The remote certificate is not valid according to the validation procedure'."

Could you please help me ?

Best Regards,
Mathias

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,221 Reputation points Microsoft Employee
    2020-08-01T16:47:46.893+00:00

    @mathiasbroutin-4005

    Please confirm if the PostGresql is on premises or it is Azure PostGresql hosted in Azure Cloud.

    Please find the official document from PostgreSql on how to use the client/server certificates.

    https://www.postgresql.org/docs/current/libpq-ssl.html

    According to the error, the trust is not happening between the client(your machine) and the server due to the setup. If the Postgresql is on prem, please contact the PostgreSql admin who can help in fixing this issue.

    Hope this information helps. Please let us know if this answers your query.

    Regards
    Navtej S

    0 comments