Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Connecting to PostgreSQL - The remote certificate is invalid according to the validation procedure

Trying to connect to PostgreSQL hosted at a virtual machine at 192.168.XX.XX, OS Ubuntu 18.10, but get an error "The remote certificate is invalid according to the validation procedure". I bought a valid certificate which resides in /etc/ssl/ folder, changed the owner of the 'server.key' file to postgres, gave 600 access privilege and restarted Postgres, but the error is still the same. What can I do to overcome the problem? Thanks!

Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Anonymous ,

    Have you checked if it connects successfully when using other PostgreSQL Client like pgAdmin? If we can't use pgAdmin connecting to your PostgreSQL, this should be a problem in PostgreSQL.

    Best Regards,

    Teige

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, TeigeGao ! Yes, I use pgAdmin without any problems.