How to install pgAdmin (web-based GUI tool for Postgres database) on Ubuntu

Update Server: apt update && apt upgrade -y

Add PostgreSQL 13 repository: sudo apt install curl gpg gnupg2 software-properties-common apt-transport-https lsb-release ca-certificates curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg echo "deb http://apt.postgresql.org/pub/repos/apt/ lsb_release -cs-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list

Install PostgreSQL 13: sudo apt update sudo apt install postgresql-13 postgresql-client-13 systemctl status postgresql@13-main.service

Test PostgreSQL Connection: sudo su - postgres psql CREATE DATABASE mytestdb; CREATE USER mytestuser WITH ENCRYPTED PASSWORD 'your_password'; GRANT ALL PRIVILEGES ON DATABASE mytestdb to mytestuser; \q exit

Add pgAdmin4 repository: curl -fsSL https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/pgadmin.gpg sudo sh -c 'echo "deb

I'm replacing angled bracket with square bracket

https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" ] /etc/apt/sources.list.d/pgadmin4.list' cat /etc/apt/sources.list.d/pgadmin4.list

Install pgAdmin4: sudo apt update sudo apt install pgadmin4 systemctl status apache2

Configure Apache Web Server: sudo /usr/pgadmin4/bin/setup-web.sh

Access pgAdmin 4 Web interface: sudo ufw allow http sudo ufw allow https

server_ip/pgadmin4 ... https://www.youtube.com/watch?v=m4TDO34a6vQ