blob: 389be1e4b42bbe8d11e44a11513748d34eadca2a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
[
{ type: install
message: <<EOM
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.
EOM
}
]
|
