Re: [PHP-DB] Verifying PostgreSQL Certficates

Angus B. Atkins-Trimnell wrote:
> Hello,
> 
> I have been wondering if the resource object returned from a 
> pg_connect() or pg_pconnect() call can be parsed for certain 
> information.  Specifically, I'm wondering if it contains information 
> about the certificate and public key submitted by PostgreSQL when SSL is 
> enabled.  I've looked at pg_parameter_status(), but it doesn't seem to 
> get the information I need.  Ultimately, I would like to compare the 
> signature on a certificate to a trusted certificate authority to 
> determine the trustworthiness of the certificate.

AFAIK you don't have to do this, postgres does it automatically when you 
connect.

Probably best asking the postgres-general list 
(http://www.postgresql.org/community/lists/) this instead of on a php 
list, as postgres would need to support it before php could access that 
info (and I don't know if it can tell you this info).

-- 
Postgresql & php tutorials
http://www.designmagick.com/