PostgreSQL SSL setup DigitalOcean

Question

I am trying to connect pgAdmin to digitalOcean. However I am getting this error:

I add the certificate but digital ocean didn't provided me a key file. Where could I find it?

This Is how I add the certificate file.

Thank you,

Jonathan Prieto

Laurenz Albe · Accepted Answer · 2020-07-03 05:34:04Z

5

I think that the certificate that DigitalOcean provided is for the “Root certificate” field.

It is to verify the server, not to authenticate the client.

With the default configuration of libpq you don't need the certificate at all, and SSL is used only to encrypt the communication.

answered Jul 3, 2020 at 5:34

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pifor · Accepted Answer · 2020-07-03 05:13:02Z

0

You need to create this private key with openssl command.

Unfortunately client certificate setup is not documented in the PostgreSQL official documentation.

You should try to adapt "Step 4: Generating the Client Key and Certificate" to your configuration.

answered Jul 3, 2020 at 5:13

pifor

7,9722 gold badges12 silver badges18 bronze badges