FreshPorts -- The Place For Ports notbugIf you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

Port details
powa-archivist PostgreSQL workload analyzer background worker
3.1.1.a.20161106 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port
Maintainer: girgen@FreeBSD.org search for ports maintained by this maintainer
Port Added: 29 Sep 2016 22:42:29
License: PostgreSQL
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.

WWW: http://powa.readthedocs.org/en/latest/powa-archivist/index.html
SVNWeb : Homepage : PortsMon
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (20 items)
  1. /usr/local/share/licenses/powa-archivist-3.1.1.a.20161106/catalog.mk
  2. /usr/local/share/licenses/powa-archivist-3.1.1.a.20161106/LICENSE
  3. /usr/local/share/licenses/powa-archivist-3.1.1.a.20161106/PostgreSQL
  4. lib/postgresql/powa.so
  5. share/doc/postgresql/extension/powa-CHANGELOG.md
  6. share/doc/postgresql/extension/powa-CONTRIBUTORS.md
  7. share/doc/postgresql/extension/powa-INSTALL.md
  8. share/doc/postgresql/extension/powa-LICENSE.md
  9. share/doc/postgresql/extension/powa-PL_funcs.md
  10. share/doc/postgresql/extension/powa-README.md
  11. share/postgresql/extension/powa--2.0--2.0.1.sql
  12. share/postgresql/extension/powa--2.0.1.sql
  13. share/postgresql/extension/powa--3.0.0--3.0.1.sql
  14. share/postgresql/extension/powa--3.0.0.sql
  15. share/postgresql/extension/powa--3.0.1.sql
  16. share/postgresql/extension/powa--3.0.1--3.1.0.sql
  17. share/postgresql/extension/powa--3.1.0.sql
  18. share/postgresql/extension/powa--3.1.0--3.1.1.sql
  19. share/postgresql/extension/powa--3.1.1.sql
  20. share/postgresql/extension/powa.control
  21. Collapse this list.

To install the port: cd /usr/ports/databases/powa-archivist/ && make install clean
To add the package: pkg install powa-archivist

PKGNAME: powa-archivist

distinfo:

TIMESTAMP = 1496357604
SHA256 (dalibo-powa-archivist-3.1.1.a.20161106-521fdf_GH0.tar.gz) = 9d1a613800ba527e987af0b37fa571924be17d66e7c783faa9190e88fc60e533
SIZE (dalibo-powa-archivist-3.1.1.a.20161106-521fdf_GH0.tar.gz) = 58175


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. gmake : devel/gmake
  2. vacuumlo : databases/postgresql95-contrib
  3. postgres : databases/postgresql95-server
Runtime dependencies:
  1. pg_stat_kcache.so : databases/pg_stat_kcache
  2. pg_qualstats.so : databases/pg_qualstats
  3. vacuumlo : databases/postgresql95-contrib
  4. postgres : databases/postgresql95-server
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
gmake pgsql:9.4+

pkg-message:
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.

Master Sites:
  1. https://codeload.github.com/dalibo/powa-archivist/tar.gz/521fdf?dummy=/

Number of commits found: 4

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
10 Aug 2017 08:24:05
Original commit files touched by this commit  3.1.1.a.20161106
Revision:447667
girgen search for other commits by this committer
Update to a preversion 3.1.1

This fixes a problem with an infinite loop.
25 Oct 2016 22:28:22
Original commit files touched by this commit  3.1.0
Revision:424658
mat search for other commits by this committer
Cleanup USE_GITHUB usage.

Sponsored by:	Absolight
01 Oct 2016 14:23:23
Original commit files touched by this commit  3.1.0
Revision:423065
girgen search for other commits by this committer
powa-archivist requires PostgreSQL 9.4 or greater
29 Sep 2016 22:42:19
Original commit files touched by this commit  3.1.0
Revision:422953
girgen search for other commits by this committer
Add a suite of real time metrics tools for PostgreSQL

The PostgreSQL Workload Analyzer is performance tool for PostgreSQL 9.4 and
later, allowing to collect, aggregate and purge statistics on a PostgreSQL
instance from various sources. It is implemented as a background worker.

pg_qualstats, providing data about predicates, i.e. where clauses

Number of commits found: 4

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
mariadb100-serverJan 19
mariadb101-serverJan 19
mariadb102-serverJan 19
mariadb55-serverJan 19
mysql55-serverJan 19
mysql56-serverJan 19
mysql57-serverJan 19
percona55-serverJan 19
percona56-serverJan 19
percona57-serverJan 19
phpbb3Jan 19
unboundJan 19
wordpressJan 19
wordpressJan 19
wordpressJan 19

11 vulnerabilities affecting 94 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2018-01-19 16:44:07


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 32654
Broken 131
Deprecated 95
Ignore 371
Forbidden 0
Restricted 172
No CDROM 77
Vulnerable 46
Expired 8
Set to expire 86
Interactive 0
new 24 hours 8
new 48 hours9
new 7 days730
new fortnight1447
new month2740

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2018 Dan Langille. All rights reserved.