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...|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 [email protected]
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/packag... | 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/pgadmi... -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
Watch video How to install pgAdmin (web-based GUI tool for Postgres database) on Ubuntu online without registration, duration hours minute second in high quality. This video was added by user Quickloss3 14 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 225 once and liked it like people.