Install pgAdmin 4 on Ubuntu 18.04 / Ubuntu 16.04

How to install pgAdmin4 on Ubuntu 18.04 / Ubuntu 16.04? This article was written to guide new users to install pgAdmin 4 on Ubuntu 18.04 / Ubuntu 16.04. pgAdmin is a feature-rich, open source PostgreSQL management and development platform that runs on Linux, Unix, Mac OS X and Windows.

With pgAdmin, you can manage the PostgreSQL database server from version 9.2 using an intuitive and powerful web interface. We have guides for installing pgAdmin 4 on other platforms.

How to install pgAdmin 4 on Debian

How to install pgAdmin 4 on CentOS 7

How to install pgAdmin4 on FreeBSD 12

See the above guide and the official pgAdmin documentation for platforms that are different from shared platforms. If you are running an Ubuntu system or Linux Mint, this guide will work for you. Linux Mint 19 users should use the Ubuntu 18.04 repository, while Mint 18 uses the Ubuntu 16.04 repository.

Install pgAdmin4 on Ubuntu 18.04 / Ubuntu 16.04

One requirement for installing pgAdmin4 on Ubuntu 18.04 / Ubuntu 16.04 is a PostgreSQL server. You can choose to use any version of PostgreSQL server> = 9.6. We have some guides that you can use as a reference when installing a PostgreSQL database server.

Install PostgreSQL 12 on Ubuntu

Install PostgreSQL 11 on Ubuntu

After completing the installation of the PostgreSQL database server on Ubuntu, proceed to install and start pgAdmin4 on Ubuntu 18.04 / Ubuntu 16.04. as follows

Add PostgreSQL APT repository

The PostgreSQL Global Development Group (PGDG) maintains an APT repository of PostgreSQL packages for Debian and Ubuntu. You can add a repository using the commands shown below.

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list

The added repository contains many different packages, including third-party plugins. mainly:

  • PostgreSQL client
  • PostgreSQL Core database server
  • libpq development
  • PostgreSQL server development
  • pgadmin package

Install pgAdmin4 on Ubuntu 18.04 / Ubuntu 16.04

Finally, update the package list.

sudo apt update

To install the pgAdmin4 package on Ubuntu 18.04 / Ubuntu 16.04 systems, run the following command and provide the correct version number:

sudo apt update
sudo apt install pgadmin4 pgadmin4-apache2

During the installation process, you will be asked to configure an initial user account. Provide an email address.

Set administrator password at the same time

Install pgAdmin4 on Ubuntu

The Apache service should be started after installation.

$ systemctl status apache2
● apache2.service - The Apache HTTP Server
   Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
           └─apache2-systemd.conf
   Active: active (running) since Sun 2019-10-06 13:47:00 UTC; 23s ago
 Main PID: 5678 (apache2)
    Tasks: 83 (limit: 2362)
   CGroup: /system.slice/apache2.service
           ├─5678 /usr/sbin/apache2 -k start
           ├─5682 /usr/sbin/apache2 -k start
           ├─5683 /usr/sbin/apache2 -k start
           └─5684 /usr/sbin/apache2 -k start

Oct 06 13:47:00 ubuntu18 systemd[1]: Stopped The Apache HTTP Server.
Oct 06 13:47:00 ubuntu18 systemd[1]: Starting The Apache HTTP Server...
Oct 06 13:47:00 ubuntu18 systemd[1]: Started The Apache HTTP Server.

If you have a UFW firewall configured, http and https communication is allowed.

sudo ufw allow http
sudo ufw allow https

Open your browser and http://[ServerIP_or_domain]/pgadmin4.

Install pgAdmin4 on Ubuntu

Sign in with your set email address and password.

Install pgAdmin4 on Ubuntu

Wait a few seconds to complete the initialization.

Install pgAdmin4 on Ubuntu

On the pgAdmin homepage, add a PostgreSQL server to manage with pgAdmin by clicking “Add new server.” This can be a local or remote PostgreSQL server.

Install pgAdmin4 on Ubuntu

under “Fair” Section, give the server a name and description.

Install pgAdmin4 on Ubuntu

Down “Connect” The tab provides access details-database host, database user and password.

Install pgAdmin4 on Ubuntu

When done, click Save Button to save the configuration. If you successfully added the server, the name will appear in the left sidebar.

Install pgAdmin4 on Ubuntu

Select a server to view database summary information and make changes. Learn more about how to use pgAdmin from the documentation page.

related:

Install PostgreSQL 12 on Ubuntu 18.04 / Ubuntu 16.04

Best free and open source web hosting control panel

How to Install ClickHouse Parsing DBMS on Ubuntu

How to install ArangoDB on Ubuntu 18.04 Bionic Beaver

label:

  • Install pgAdmin 4 on Ubuntu 18.04
  • Install pgAdmin 4 on Ubuntu 16.04
  • Install pgAdmin 4 on Ubuntu 18.04 / Ubuntu 16.04
  • Install pgAdmin 4 on Ubuntu
Sidebar