o7planning

Install pgAdmin 3, 4 on Ubuntu

View more Tutorials:

Follow us on our fanpages to receive notifications every time there are new articles. Facebook Twitter

1- Install pgAdmin4

On Ubuntu, open Terminal window and execute the following commands:

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" >> /etc/apt/sources.list.d/pgdg.list'

sudo apt install wget ca-certificates

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add

sudo apt update

sudo apt install pgadmin4

After installing successfully, you can see pgAdmin4 on your Ubuntu.  
Apart from the pgAdmin3, pgAdmin4 runs on the browser. Below is the first running image of this program.
Your pgAdmin is not connected to any Postgres Server. Right click on "Servers" and select "Create >> Server" to create a connection to a Postgres Server .
Postgres has been installed on my computer and I will connect to this Database Server. OK, on the "General" tab, name your server, for example, "MyLocalServer".
On the "Connection" tab, enter the information related to your Database Server, for example,  host, post, username, password,... After that, click on Save.
OK, a Server has just been created and you can manage this Postgres Server on the pgAdmin.

2- Install pgAdmin3

Below is the instruction for installation of pgAdmin3 on the Ubuntu. Most people will use pgAdmin4, but this guidance may still be useful to someone.
Note: The following screenshots are performed on Ubuntu Server. However, there is no difference if you use Ubuntu Desktop.

sudo apt-get install pgadmin3
After installation, on the Ubuntu, you can  you can access pgAdmin3
The illustration that the pgAdmin3 is running on Ubuntu Server:
Enter the connection information to the server installed PostGres. Herein, I connect to the PostGres installed on the local computer.

View more Tutorials:

Maybe you are interested

These are online courses outside the o7planning website that we introduced, which may include free or discounted courses.