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

[vysokovsky]

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!

[TeigeGao]

Hi @vysokovsky ,

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

[vysokovsky]

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