pgAdmin 4
Install (Windows)
Install (Windows)
Download and run the .exe file.
Install (Linux)
Install (Linux)
Using apt...
Using apt...
Tested on Ubuntu 18.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/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'
Desktop and Web
Desktop and Web
sudo apt install pgadmin4
sudo /usr/pgadmin4/bin/setup-web.sh
Desktop Only
Desktop Only
sudo apt install pgadmin4-desktop
Web Only
Web Only
sudo apt install pgadmin4-webÂ
sudo /usr/pgadmin4/bin/setup-web.sh
Run
Run
pgadmin4
In you browser, connect to:
http://127.0.0.1:43447/browser/#
Connect to RDS PostgreSQL
Connect to RDS PostgreSQL
This relies on an ssh tunnel with port forwarding via a Bastion Host.
The security group configuration must allow traffic on port 5432 between the Bastion Host and the RDS Server
This is an Inbound rule to the Security Group covering the RDS server to allow connections on 5432 from the Bastion Security Group
Bibliography
Bibliography
https://www.pgadmin.org/https://www.pgadmin.org/download/pgadmin-4-apt/https://www.pgadmin.org/docs/pgadmin4/4.21/index.htmlhttps://www.pgadmin.org/screenshots/#1https://www.enterprisedaddy.com/2016/12/connect-embedded-vcenter-6-5-postgres-database-via-pgadmin/https://stackoverflow.com/questions/62324520/how-to-use-ssh-tunnel-to-connect-to-an-rds-instance-via-an-ec2-instance