pgAdmin 4
pgAdmin 4 is the web-based administration and development platform for PostgreSQL. It browses and edits database objects, runs queries in a SQL editor with explain plans, and handles backups, restores, roles and server monitoring for any number of PostgreSQL servers.
pgAdmin 4
In Development
This script is currently in active development and may be unstable or incomplete. Use in production environments is not recommended.
This script is currently in active development and may be unstable or incomplete. Use in production environments is not recommended.
Installation
Default install:
1
bash -c "$(curl -fsSL https://raw.githubusercontent.com/community-scripts/DevScripts/main/tools/addon/pgadmin.sh)"
Notes
Run it inside an existing Debian or Ubuntu LXC (amd64 only), typically the one running PostgreSQL. pgAdmin is served at http://[IP]/pgadmin4.
The login email and a generated password are shown once at the end of the install and are not saved anywhere else.
Lost the password: run
/usr/pgadmin4/venv/bin/python3 /usr/pgadmin4/web/setup.py update-user <email> --password <new> in the container. Saved server passwords must then be entered again.