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.
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.
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
steve/testin 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
pgAdminto 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 "Require" 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
You can read more about how to use pgAdmin from the official documentation
Updated 2 months ago