PostgreSQL performances monitoring and auditing tool
Project homepage: https://pgcluu.darold.net/
Description
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 information of the PostgreSQL
Cluster and the system utilization.
Package information
- Ports path
- databases/pgcluu
- Package architecture
- amd64
- Maintainer
- The OpenBSD ports mailing-list <ports@openbsd.org>
- Categories
- databases, sysutils
- Available flavors
- None listed
Ports list build and test dependencies as well as runtime dependencies. pkg_add selects those needed for installation.
Direct dependencies
None listed.
OpenBSD README
+-----------------------------------------------------------------------
| Running pgcluu 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
Limitations
===========
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.