"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)
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.