Postico

Postico is a proprietary mac app for Postgres that you can use to connect to your Crunchy Bridge cluster. For this walkthrough, we assume you already have Postico installed on your machine.

Find your connection information

If you haven't created a Crunchy Bridge Team or Cluster, the Getting Started page will guide you through the process.

Once you've created a cluster, navigate to the cluster's Connection tab and access the connection details formatted as a URL, which will look like this:

postgres://[email protected]:5432/meteors
Copy

You'll notice that a connection string URL has this general format:

postgres://user:password@host:port/database
Copy

Adding your connection details

Go to the connection panel in Postico and click the "New Server from URL" button to add your cluster's connection string URL. Postico will use the URL to fill in the details, and from there you can adjust any additional settings. Leave the window open and move to the next section if you'd like to add your root certificate here for SSL mode, otherwise you can click Connect.

Certificate verification

For an additional layer of security, you can choose to have to Postico connect using SSL mode, which verifies the self-signed root certificate associated with your Crunchy Bridge Team.

First, you'll need to download the certificate for the Team that owns the cluster to which you want to connect. To find it, navigate to the Team Overview page by clicking on the name of the team in the Dashboard. Then click into the Settings tab to locate and download the certificate. Read more about certificates on the SSL Concepts page.

Next, you'll return to the connection panel you have open in Postico and add the certificate file you've downloaded in the Server CA section.

That's it! Click Connect and you should have Postico connected to your Crunchy Bridge cluster.