BSD Portsdatabases/powa-archivist 5.3.0 FreeBSD
PostgreSQL workload analyzer background worker
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
a6f1534d00- License
- PostgreSQL
- Categories
- databases
- Package size
- 57.3 KiB, 2896.1 KiB installed
Description
This project is the core extension of the PoWA project, a PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/powa-archivist | 5.3.0 |
| DragonFly | databases/powa-archivist | 5.0.1 |
| HardenedBSD | databases/powa-archivist | 5.3.0 |
| GhostBSD | databases/powa-archivist | 5.3.0 |
Install
Binary package:
pkg install powa-archivistFrom the ports tree:
cd /usr/ports/databases/powa-archivist/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= powa-archivist>0:databases/powa-archivistPackages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 5.3.0 | 5.3.0 | 4.1.4 | 5.0.3 | 5.3.0 |
| FreeBSD:14:quarterly | 5.3.0 | 5.3.0 | n/a | 5.0.3 | 5.3.0 |
| FreeBSD:15:latest | 5.3.0 | 5.3.0 | n/a | 5.0.3 | 5.0.3 |
| FreeBSD:15:quarterly | 5.3.0 | 5.3.0 | n/a | n/a | n/a |
| FreeBSD:16:latest | 5.3.0 | 5.3.0 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Runtime 2
${LOCALBASE}/lib/postgresql/pg_stat_kcache.so: databases/pg_stat_kcache${LOCALBASE}/lib/postgresql/pg_qualstats.so: databases/pg_qualstats
The full lists below include those, and their dependencies in turn.
Build dependencies 12
Run dependencies 13
No port depends on this one.
Configuration
No options to configure.
- USES
- gmake pgsql:11+
- Service scripts
- none
Message after installing
To activate powa-archvist on your PostgreSQL server, add 'powa' to the list of shared_preload_libraries in $PGDATA/postgresql.conf: shared_preload_libraries = 'pg_stat_statements,powa' track_io_timing = on Also, create the powa database and add extensions createdb powa psql -d powa -c " CREATE EXTENSION pg_stat_statements; CREATE EXTENSION btree_gist; CREATE EXTENSION powa; " After this, restart postgresql to start the background worker. See http://powa.readthedocs.org/en/latest/powa-archivist/installation.html#id1 for detailed installation instructions. Optionally, but warmly recommended, is the use of databases/pg_qualstats and databases/pg_stat_kcache together with powa. Use the databases/powa-web port to visualize the data.
Files
pkg-plist 25
- lib/postgresql/powa.so
- share/doc/postgresql/extension/powa-CHANGELOG.md
- share/doc/postgresql/extension/powa-CONTRIBUTORS.md
- share/doc/postgresql/extension/powa-INSTALL.md
- share/doc/postgresql/extension/powa-LICENSE.md
- share/doc/postgresql/extension/powa-PL_funcs.md
- share/doc/postgresql/extension/powa-README.md
- share/postgresql/extension/powa--5.0.0--5.0.1.sql
- share/postgresql/extension/powa--5.0.0.sql
- share/postgresql/extension/powa--5.0.1--5.0.2.sql
- share/postgresql/extension/powa--5.0.1.sql
- share/postgresql/extension/powa--5.0.2--5.0.3.sql
- share/postgresql/extension/powa--5.0.2.sql
- share/postgresql/extension/powa--5.0.3--5.1.0.sql
- share/postgresql/extension/powa--5.0.3.sql
- share/postgresql/extension/powa--5.1.0--5.1.1.sql
- share/postgresql/extension/powa--5.1.0.sql
- share/postgresql/extension/powa--5.1.1--5.1.2.sql
- share/postgresql/extension/powa--5.1.1.sql
- share/postgresql/extension/powa--5.1.2--5.2.0.sql
- share/postgresql/extension/powa--5.1.2.sql
- share/postgresql/extension/powa--5.2.0--5.3.0.sql
- share/postgresql/extension/powa--5.2.0.sql
- share/postgresql/extension/powa--5.3.0.sql
- share/postgresql/extension/powa.control
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| powa-team-powa-archivist-REL_5_3_0_GH0.tar.gz | 425304 | b53d5ce48bb318e3c261c7d80d1dcc612d84d22cf4a83d5473ecaa83b3380520 |