Connecting via pgAdmin

pgAdmin is a desktop client for postgres databases (including bit.io) that lets you view and administer your databases with an easy-to-use graphical interface. Once connected via pgAdmin, you can view your databases tables, schemas, and usage metrics with ease.

Installing pgAdmin

pgAdmin can be installed from the official website's download page for the operating system of your choice.

On first startup, pgAdmin requires you to create an administrator password. This password can be any password and is used to protect all of your stored bit.io credentials.

Connecting to bit.io with pgAdmin

In order to connect to bit.io with pgAdmin, you'll need to find your PosgreSQL connection credentials from the bit.io Connect Tab of the database to which you would like to connect. You can find everything you need to know about your PostgreSQL credentials here.

To begin, click the "Add server" button on the pgAdmin home page:

Next, fill out the "General" tab of the new database pop up menu by putting your bit.io database name in the "Name" section.

🚧

Be sure to use the complete database name

Complete database names are in the format username/database-name. e.g. steve/test in this example. The correctly-formatted database name can be found in the "Database" field of the connect tab of your bit.io database.

Next, fill our the "Connection" tab of the new database pop up menu by filling in your database credentials.

🚧

Make sure you copy your full database name into the "Maintenance database" field

This will instruct pgAdmin to use your database as the "Maintenance" database as opposed to the default postgres database (which may or may not exist).

📘

Don't forget to save your password for future use!

Be sure to check the "Save password" option for your convenience when re-opening pgAdmin (you will still have to enter your global admin password you set earlier to view your bit.io database).

Next, fill out the "SSL" tab of the new database pop up menu by selecting "Verify-Full" from the "SSL mode" drop down.

Now you are ready to connect! Click the "Save" button to continue, and then double click your new database on the left pane to load your data from bit.io into pgAdmin.

You can read more about how to use pgAdmin from the official documentation