As a developer, ansible-pulp will provide me with the cool postgres WebGUI
The following PoC was done. For implementation, it can be incorporated into the pulp-devel role, and pulplift.
On the host, reconnect to the pulplift VM pulp3-source-fedora31 with a new SSH tunnel (this will be added to pulplift config during implementation):
vagrant ssh pulp3-source-fedora31 -- -L 8443:127.0.0.1:8443
On the pulplift VM pulp3-source-fedora31:
Modified /var/lib/pgsql/data/pg_hba.conf to replace the 127.0.0.1 line with:
host all all 0.0.0.0/0 md5
(Because the container has a NAT'd IP address.)
Modified /var/lib/pgsql/data/postgresql.conf to contain
listen_addresses = '*'
(Because otherwise it's localhost only; see above.)
sudo systemctl restart postgresql.service sudo dnf install -y podman-docker docker pull dpage/pgadmin4 # "--restart always" will be ignored for podman-docker. Only real docker/moby-engine will use it. podman will need a systemd unit to survive VM reboots. docker run --restart always -p 8443:8443 -e 'PGADMIN_DEFAULT_EMAILemail@example.com' -e 'PGADMIN_DEFAULT_PASSWORD=SuperSecret' -e 'PGADMIN_LISTEN_PORT=8443' -d dpage/pgadmin4
Now back on your host:
Open your browser to:
And login with the username/email and password listed above.
Then create a new connection to:
The IP address of the pulplift VM
(These settings will later be set via PGADMIN_SERVER_JSON_FILE)