How to connect pgadmin with google cloud postgres with ssl certificates

Question

I am trying to connect to google cloud's postgres with ssl certificates. I have pgadmin application locally. I tried connecting by setting my ip addess in allow netwroks and it worked. But, If I emove that settinging and tried with SSL certificates its not working.

I tried all ssl modes (sllow,require, verifiy-CA,verfy-full) . But, none of these works. please help me.

Answer 1

I tried to connect by myself and now I'm able to do so using this solution:

Server Properties > Parameters (add these connection parameters):

SSL mode -> verify-ca

Connection timeout -> 10 seconds

Client certificate key -> (choose file)

Client certificate -> (choose file)

Server certificate -> (choose file)

This way works fine for me. I hope this will help someone with same problem.

Answer 2

As @jjanes said it seems like its not possible. so, I allowed to every ip address 0.0.0.0/0 and allowed connection only with ssl certificates. This worked for me.