Post

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.

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.

Web Interface

Port: 80

Source code
Loading...