SSL Certificates For PostgreSQL

[ 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."

Complete Story

Related Stories:

• How To Install VMware Server 2 On A Fedora 14 Desktop (Kernel 2.6.35)(Dec 28, 2010)
• How To Install Sphinx On Ubuntu 10.10(Dec 21, 2010)
• Installing And Using OpenVZ On Fedora 14(Dec 16, 2010)
• Helping The Random Number Generator To Gain Enough Entropy With rng-tools (Debia(Dec 13, 2010)
• Using Firewall Builder To Configure Router Access Lists(Dec 05, 2010)
• Setting Up An Active/Active Samba CTDB Cluster Using GFS & DRBD (CentOS 5.5)(Dec 03, 2010)