PostgreSQL or Postgres is a powerful and vysokoproizvoditel object-relational database management system with open source. It is ideal for large databases and supports many additional features. The database is available for most operating systems, including Linux, FreeBSD, Solaris, and Windows.
For database management GUI, we used to use the program phpmyadmin. A similar program for PostgreSQL called Phppgadmin. It is much easier to build database, table, and set role. In this article we will discuss how to install phpPgAdmin Ubuntu 18.04.
The installation of Phppgadmin in Ubuntu 18.04
I assume you already installed the Apache web server, PHP interpreter and Postgresql. About installing the LAMP Suite of programs you can read in a separate article. To install phppgadmin run:
sudo apt install phppgadmin
If you do not set a password for user postgress, you must install it:
su - postgres
psql
password postgres
And then enter your chosen password. You can then exit the command shell:
quit
Then return to your normal user with exit command. Next, you need to configure Apache. Open the file /etc/sites-available/phppgadmin.conf and make sure that the value of the Directive Require all granted, not local, otherwise the web interface can be accessed only locally:
sudo vi /etc/conf-available/phppgadmin.conf
Require all granted
By default PhpPgAdmin logged in as a superuser. This behavior can also be disabled. To do this, open /etc/phppgadmin/config.inc.php and set this line to false:
sudo vi /etc/phppgadmin/config.inc.php
$conf['extra_login_security'] = false;
Then you can access phppgadmin opening a browser and typing the path https://localhost/phppgmyadmin. Instead of localhost you can use your ip address, if the program is installed on another server:
Select PostgreSQL server and try to log in. Enter the user name postgres and the password previously specified.
Then the program will open the interface panel phpPgAdmin:
Insights
Now you know how to install phppgadmin in Ubuntu 18.04. This web interface is not much harder to set up than PhpMyAdmin, and the possibilities it makes it much easier to work with Postgresql.
Top Temporary VPS for Testing & Experiments (2026)
Need a fast cloud server for a few hours or days? Deploy an isolated testing environment, run your scripts, and destroy it without any monthly commitments. Secure payments via Crypto (USDT) & PayPal supported.
• Exclusive Welcome Bonus: Get an extra 15% on your first balance top-up within 24 hours after registration.
• Best-in-class Storage VDS configurations with huge disk space for heavy data testing.
• High-speed hardware platform with a stable presence in the Netherlands (Europe).
