SSL Certificates For PostgreSQL
Jan 02, 2011, 07:05 (0 Talkback[s])
[ Thanks to Falko
Timme for this link. ]
"This describes how to set up ssl certificates to
enable encrypted connections from PgAdmin on some client machine to
postgresql on a server machine. The assumption is that postgresql
(compiled with ssl support) and openssl are already installed and
functional on the server (Linux). PgAdmin is already installed on
the client (either Windows or Linux).
"On the server, three certificates are required in the data
directory. CentOS default is /var/lib/pgsql/data/:
root.crt (trusted root certificate)
server.crt (server certificate)
server.key (private key)
"Issue commands as root."