SHELL

install postgresql and phppgadmin client

sudo apt update
sudo apt -y upgrade

sudo apt install postgresql postgresql-client

sudo su - postgres
psql -c "alter user postgres with password 'root'"

sudo apt -y install phppgadmin php-pgsql

sudo nano /etc/phppgadmin/config.inc.php
# Set extra_login_security to false
conf['extra_login_security'] = false;

sudo systemctl restart postgresql apache2

# Visit
localhost/phppgadmin