Redshift SSL Certificates are small data files that digitally bind a cryptographic key to redshift cluster connection details. In this article, we will discuss on Redshift install SSL certificate in local system.
Redshift SSL Certificate
You have to login to AWS console to download the .pem file. To support SSL connections, Amazon Redshift creates and installs a self-signed SSL certificate on each cluster. To login to cluster, you should have an account created with Amazon AWS cloud. You can obtain the account by yourself or use the corporate account.
The public key is stored at https://s3.amazonaws.com/redshift-downloads/redshift-ssl-ca-cert.pem. You can download this and store in local system so that you can just provide the path to the downloaded file during keytool command execution.
Read:
- Netezza Aginity Setup and Configurations
- Netezza ODBC setup
- Resolution: Amazon Redshift Drop and Truncate Table Running Slow
Redshift Install SSL Certificate in Local Windows System
You can follow the below steps to install the SSL certificate in local windows system.
1.Open Command Prompt as an Administrator. You should be administrator in order to run the keytool command.
2.Navigate to bin folder of the Java installation. You have to be in the Java installation bin folder to use keytool command
3.Execute keytool command by passing .pem file which you have downloaded. You have to provide the path to the pem file that you have downloaded in earlier steps. Below is the command that you may want to use to store Redshift SSL certification:
keytool -keystore “C:\Program Files\Java\jre1.8.0_72\lib\security\cacerts” -noprompt -keypass changeit -storepass changeit -alias redshift -import -file “C:\Program Files\redshift-ssl-ca-cert.pem”
Connect to Redshift using SQL Workbench
Now you have the certificate stored on your local windows system, you can open the SQL workbench and select PostgreSQL driver to connect Redshift database.
Provide connection details such as URL, username and password to connect to Redshift database.
