Linux Today: Linux News On Internet Time.





More on LinuxToday


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

Complete Story

Related Stories: