This quickstart guide will help you get PgHero up and running with Container Apps on Crunchy Bridge. We recommend you start with the Container Apps Quickstart to get a general understanding of Container Apps.
From the PgHero project:
A performance dashboard for Postgres.
First, make sure you have Container Apps enabled. As a user with superuser
CREATE EXTENSION pgpodman; to install the extension in the
postgres database of the desired cluster.
Next, find your cluster's database URL to include as the
parameter when you run the container. You can find the URL in the Connection
section of the cluster dashboard (choose the
application role), or by running
cb uri --role application <cluster name> on the command line.
To start your PgHero app, run the following using your own values for
SELECT run_container('-dt -p 5433:8080/tcp -e DATABASE_URL="your-database-URL" -e PGHERO_USERNAME="your-username" -e PGHERO_PASSWORD="your-password" ankane/pghero');
Now you can visit your running PGHero dashboard at your-host-URL:5433. You can
find your Host URL in the Overview section of your cluster dashboard, or by
cb info <cluster name>.