PgHero quickstart

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.

About PgHero

From the PgHero project:

A performance dashboard for Postgres.

PgHero with container apps quickstart

First, make sure you have Container Apps enabled. As a user with superuser privileges, run 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 DATABASE_URL 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 DATABASE_URL, PGHERO_USERNAME, and PGHERO_PASSWORD:

SELECT run_container('-dt -p 5433:8080/tcp -e DATABASE_URL="your-database-URL" -e PGHERO_USERNAME="your-username" -e PGHERO_PASSWORD="your-password" --privileged docker.io/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 running cb info <cluster name>.