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) The link for this article located at HowtoForge is no longer available. . Enhance PostgreSQL security by setting up SSL certificates for secure connections through PgAdmin with these essential steps and commands. SSL Certificates, PostgreSQL Security, PgAdmin Configuration. . LinuxSecurity.com Team
Get the latest Linux and open source security news straight to your inbox.