pgAdmin

Connecting with pgAdmin

pgAdmin is an open source database tool that you can use to connect to your Crunchy Bridge cluster. For this walkthrough, we assume you already have pgAdmin installed on your machine or running in a shared resource.

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 for environment variables or yaml, which will give you the host name, database name, username, and password:

Adding your connection details

Go to the server group you'd like to put your cluster in and click Register --> Server link. Paste in the host name, username, and password for the account you're logging into:

You may also want to include the name of the particular database to which you want to connect.

Certificate verification

For an additional layer of security, you can choose to connect to pgAdmin using SSL mode: verify-full, 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, navigate to the Parameters screen in PgAdmin's server connection details. You'll add the certificate file you've downloaded as a new item called Root certificate. Then you will change the SSL mode to verify-full: