0

I am testing SSL connection with Postgresql. Can anyone help me in giving me the steps for this kind of testing. I need to test both on Windows as well as Centos.

Improve this question
8
  • Can you share what you've done so far? Are you just struggling to pass the certificates / key in the connection string? Commented May 2, 2018 at 5:57
  • Well I a very new in SSL testing and I need to understand how to proceed with testing like certificate generation, putting at client directory etc. So can you help me in giving the steps or giving me any docs. to refer Commented May 2, 2018 at 6:11
  • 1
    a few links to get started: postgresql.org/docs/10/static/ssl-tcp.html and stackoverflow.com/questions/14021998/… Commented May 2, 2018 at 6:13
  • Hi I have created the server.cert, server.key and root.cert and put it in the /data directory in windows. Also, i have put the same files in the C:\Users\xxxxx\AppData\Roaming\postgresql files.As of now i am doing only one way ssl testing . Now i am getting the error as :Error - SSL error: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target Commented May 3, 2018 at 6:36
  • does postgres have access to these files? It might be a permission issue - I haven't worked with Windows for the last 15 years, so I cannot tell you exactly where to change it. Commented May 3, 2018 at 6:45
Related questions
2
Resolving "ssl handshake failure" error in PostgresQL
158
Using psql to connect to PostgreSQL in SSL mode
3
Enable SSL connections on PostgreSQL server
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.