The databases/pgcluu port

pgcluu-3.1 – PostgreSQL performances monitoring and auditing tool (cvsweb github mirror)


PgCluu is a PostgreSQL performances monitoring and auditing tool.  View
reports of all statistics collected from your PostgreSQL databases
cluster. pgCluu will show you the entire informations of the PostgreSQL
Cluster and the system utilization.
WWW: https://pgcluu.darold.net/


| Running ${PKGSTEM} on OpenBSD

PostgreSQL Authentication
In order for pgcluu to authenticate to PostgreSQL when a password is
required you need to create a `.pgpass` file in the home directory of
the user running pgcluu(1). By default that would be in `/root`, e.g.:

    # echo "localhost:5432:*:postgres:postgres" >> ~/.pgpass
    # chmod 0600 ~/.pgpass

Please refer to the PostgreSQL documentation for more information
regarding the pgpass file: http://www.postgresql.org/docs/9.3/static/libpq-pgpass.html

Generating reports
To generate reports in the default setup (assuming the output
directory is `/var/www/pgcluu/`:

    # pgcluu --disable-sar -o /var/www/pgcluu /var/db/pgcluu

pgcluu_collectd(1) requires the `sar` binary from the sysstat project
to gather various pieces of operating system information. However
sysstat has not been ported to OpenBSD and therefore pgcluu(1) won't
be able to display memory/filesystem usage, etc.


The OpenBSD ports mailing-list


databases sysutils