Postgres UI Client Setup Ubuntu
Published in
Aug 18, 2021
Postgres client
sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pubsudo apt-key add
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 && apt update’
sudo apt install pgadmin4-web
RUNNING
sudo /usr/pgadmin4/bin/setup-web.sh (use any mail and password)
open url (use same mail and password)
click on add server
name your server
add ip and port in the connections tab
add username and password of Postgres server
click save to add server
Usage
Go to your port on Localhost anytime to monitor, view or even run SQL commands.