SHELL

install pgadmin4 ubuntu 20.04

curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add -
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list'

step10 pgadmin ubuntu 20.04

sudo ufw allow http
sudo ufw allow https

step5 pgadmin ubuntu 20.04

sudo apt install pgadmin4

install pgadmin ubuntu 20.04

curl  -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/pgadmin.gpg

step6 pgadmin ubuntu 20.04

$ systemctl status apache2
● apache2.service - The Apache HTTP Server
     Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
     Active: active (running) since Wed 2022-05-18 17:31:53 EAT; 35s ago
       Docs: https://httpd.apache.org/docs/2.4/
    Process: 8845 ExecStart=/usr/sbin/apachectl start (code=exited, status=0/SUCCESS)
   Main PID: 8849 (apache2)
      Tasks: 55 (limit: 9460)
     Memory: 15.0M
        CPU: 67ms
     CGroup: /system.slice/apache2.service
             ├─8849 /usr/sbin/apache2 -k start
             ├─8850 /usr/sbin/apache2 -k start
             └─8851 /usr/sbin/apache2 -k start

Mei 18 17:31:53 ubuntu22 systemd[1]: Starting The Apache HTTP Server...
Mei 18 17:31:53 ubuntu22 apachectl[8848]: AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppre>
Mei 18 17:31:53 ubuntu22 systemd[1]: Started The Apache HTTP Server.

step2 pgadmin ubuntu 20.04

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list'

step7 pgadmin ubuntu 20.04

sudo /usr/pgadmin4/bin/setup-web.sh

step2 pgadmin ubuntu 20.04

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list'

step8 pgadmin ubuntu 20.04

Setting up pgAdmin 4 in web mode on a Debian based platform...
Creating configuration database...
NOTE: Configuring authentication for SERVER mode.

Enter the email address and password to use for the initial pgAdmin user account:

Email address: <input-email-address>
Password: <input-password>
Retype password: <Reenter-password>
pgAdmin 4 - Application Initialisation
======================================

Creating storage and log directories...

step9 pgadmin ubuntu 20.04

We can now configure the Apache Web server for you. This involves enabling the wsgi module and configuring the pgAdmin 4 application to mount at /pgadmin4. Do you wish to continue (y/n)? y
The Apache web server is running and must be restarted for the pgAdmin 4 installation to complete. Continue (y/n)? y
Apache successfully restarted. You can now start using pgAdmin 4 in web mode at http://127.0.0.1/pgadmin4