Hi,
I have setup an apache server with SSL.
I create a CA, serker.key, server.crt.
I create a user.key and user.cert.
Now the apache server accept only the correct certificate for login on a given directory.
I have a PHP script that query the database using the HTTP login/password as PostgreSQL user/password.
I plan to add the same SSL setup to PostreSQL.
1) Is it possible to use the SSL authentification done by apache with PostgreSQL ?
2) How the DN of the certificate is match against an PostgreSQL role ?
Any help is welcomed.
Pailloncy Jean-Gerard