Re: SSL Connection help, pls... - Mailing list pgsql-novice

From Tom Lane
Subject Re: SSL Connection help, pls...
Date
Msg-id 15363.1264631514@sss.pgh.pa.us
Whole thread Raw
In response to SSL Connection help, pls...  (Richard Troy <rtroy@ScienceTools.com>)
Responses Re: SSL Connection help, pls...  (Richard Troy <rtroy@ScienceTools.com>)
List pgsql-novice
Richard Troy <rtroy@ScienceTools.com> writes:
> Although I think I've got everything configured correctly, I'm not getting
> ssl encrypted connections to be accepted. Also, havent' figured out how to
> tell psql to try _only_ an ssl-type connection.

I don't know the answer to your problems offhand, but a few suggestions:

* Read the version of the docs corresponding to your server version,
  not earlier or later ones.  This stuff changes.
* Look in the postmaster log to see what gets logged during a failed
  connection attempt.
* I do know about try-only-SSL, it's driven by an environment variable:
  export PGSSLMODE=require
* The docs only cover SSL in the context of psql and other libpq-based
  clients.  For JDBC you should probably ask on pgsql-jdbc.  But try to
  get psql working first.

            regards, tom lane

pgsql-novice by date:

Previous
From: Richard Troy
Date:
Subject: SSL Connection help, pls...
Next
From: Tom Lane
Date:
Subject: Re: Database handle destroyed without explicit disconnect