Skip site navigation (1) Skip section navigation (2)

Re: SSL Connection help, pls...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Troy <rtroy(at)ScienceTools(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SSL Connection help, pls...
Date: 2010-01-27 22:31:54
Message-ID: 15363.1264631514@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Richard Troy <rtroy(at)ScienceTools(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-01-27 22:41:57
Subject: Re: Database handle destroyed without explicit disconnect
Previous:From: Richard TroyDate: 2010-01-27 21:44:30
Subject: SSL Connection help, pls...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group