Installing an SSL Certificate for a Database Connection

If you connect to the database using SSL, you must install an SSL certificate.

Perform this task on the computer where Team Studio server is installed. You might need to run as either administrator or root user.

Prerequisites

  • You must have created and saved to the server computer a certificate server.crt to install.
  • You must ensure that the server is configured to support SSL.
  • You must have write access to the computer where Team Studio server is installed.

Procedure

  1. Copy the certificate (server.crt) from the database server to the web-server that hosts Team Studio.
  2. Open the command line on the computer, and then change the directory to the folder where the file server.crt is copied.
  3. Run the command openssl x509 -in server.crt -out server.crt.der -outform der.
  4. Run the keytool command. 
    keytool -keystore $JAVA_HOME/lib/security/cacerts -alias postgresql -import -file server.crt.der
  5. Restart Team Studio.
    You should be able to create a connection to an SSL-enabled PostgreSQL, Pivotal HAWQ, or Greenplum database.

What to do next

See documentation PostgreSQL JDBC/SSL Connections for more details.

For more information, see Installing Stored Procedures on Greenplum.

Related concepts
Related tasks