Redshift / Postgres Connection Information

Securing your connection

The most secure way to connect to your databases is within Platform.  If you'd like to connect directly from outside of Platform, we recommend doing this over the VPN.

If you want to connect without the VPN, and are willing to accept the security risk of doing so, you'll need to send in a support ticket with the IP addresses you plan to access from.

Connection settings

You can connect to a Redshift or Postgres database with most SQL applications, such as psql and DBeaver.  Fill out the connection information as follows:

• Driver/database type: PostgreSQL
• Driver/properties: ssl=true, sslfactory=org.postgresql.ssl.NonValidatingFactory
• Host: You can find the hostname via the API or through your browser by visiting this page.  The hostname will be after "jdbc:postgresql://" and before ":5432/dev".  It should look something like "redshift.example.orgs.civis.io" or "postgres.example.orgs.civis.io".
• Port: 5432 (should be default already)
• DB/Schema: name of your db/schema. ex: dev