How To Install phppgadmin on Ubuntu

Posted on April 1, 2023  (Last modified on May 20, 2023 )

3 minutes  • 442 words

Introduction

In this tutorial we learn how to install phppgadmin on Ubuntu.

What is phppgadmin

phppgadmin is:

phpPgAdmin is a web-based administration tool for PostgreSQL. It is perfect for PostgreSQL DBAs, newbies and hosting services.

Features:

• Administer multiple servers
• Manage all aspects of:
  • Users & groups
  • Databases
  • Schemas
  • Tables, indexes, constraints, triggers, rules & privileges
  • Views, sequences & functions
  • Advanced objects
  • Reports
• Easy data manipulation:
  • Browse tables, views & reports
  • Execute arbitrary SQL
  • Select, insert, update and delete
• Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
• Import SQL scripts, COPY data, XML, CSV and Tabbed
• Supports the Slony master-slave replication engine
• Excellent language support:
  • Available in 27 languages
  • No encoding conflicts. Edit Russian data using a Japanese interface!
• Easy to install and configure

There are three methods to install phppgadmin on Ubuntu. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.

Install phppgadmin Using apt-get

Update apt database with apt-get using the following command.

sudo apt-get update

After updating apt database, We can install phppgadmin using apt-get by running the following command:

sudo apt-get -y install phppgadmin

Install phppgadmin Using apt

Update apt database with apt using the following command.

sudo apt update

After updating apt database, We can install phppgadmin using apt by running the following command:

sudo apt -y install phppgadmin

Install phppgadmin Using aptitude

If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.

sudo aptitude update

After updating apt database, We can install phppgadmin using aptitude by running the following command:

sudo aptitude -y install phppgadmin

How To Uninstall phppgadmin on Ubuntu

To uninstall only the phppgadmin package we can use the following command:

sudo apt-get remove phppgadmin

Uninstall phppgadmin And Its Dependencies

To uninstall phppgadmin and its dependencies that are no longer needed by Ubuntu, we can use the command below:

sudo apt-get -y autoremove phppgadmin

Remove phppgadmin Configurations and Data

To remove phppgadmin configuration and data from Ubuntu we can use the following command:

sudo apt-get -y purge phppgadmin

Remove phppgadmin configuration, data, and all of its dependencies

We can use the following command to remove phppgadmin configurations, data and all of its dependencies, we can use the following command:

sudo apt-get -y autoremove --purge phppgadmin

Dependencies

phppgadmin have the following dependencies:

• libapache2-mod-php
• libjs-jquery
• libphp-adodb
• php-common
• php-pgsql
• php-mbstring

References

• phppgadmin website

Summary

In this tutorial we learn how to install phppgadmin package on Ubuntu using different package management tools: apt, apt-get and aptitude.