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
And then enter your chosen password. You can then exit the command shell:
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 http://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:
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.