Spring 5.0 By Example

Installing and configuring pgAdmin3

To connect on our PostgreSQL instance, we will use pgAdmin 3, which is the free tool provided by the Postgres team.

To install pgAdmin 3, we can use the following command:

sudo apt-get install pgadmin3 -y

This will install pgAdmin 3 on our machine.

After installation, open pgAdmin 3 and then click on Add a connection to a server. The button looks like this:

Then, fill in the information, as shown in the following screenshot:

The password should be: cms@springfive.

Awesome, our pgAdmin 3 tool is configured. ...