Pulp

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_EMAIL=user@domain.com'     -e 'PGADMIN_DEFAULT_PASSWORD=SuperSecret' -e 'PGADMIN_LISTEN_PORT=8443'     -d dpage/pgadmin4

Now back on your host:

Open your browser to:
http://127.0.0.1:8443/
And login with the username/email and password listed above.

Then create a new connection to:
The IP address of the pulplift VM
database: pulp
user: pulp
password: pulp
(These settings will later be set via PGADMIN_SERVER_JSON_FILE)

Rererence:
https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html#examples