Skip to content
Snippets Groups Projects

Fixup eventlogging deploy guide

Merged Bryan R requested to merge b/deploy-guide-1-fixup into master
1 file
+ 26
2
Compare changes
  • Side-by-side
  • Inline
@@ -27,12 +27,36 @@ create table heap_event (
heap_event_id bigserial primary key,
import_id bigserial not null references eventlog_import (import_id),
package_id bigserial not null references package (package_id),
timestamp int,
timestamp bigint,
measure heap_measure not null,
value integer
value bigint
);
```
### SQL privileges
Read and write privs for the script runner.
Read privs for grafana.
*During deployment, privileges were actually applied with trial and error. This
was written after the fact. Caveat emptor.*
```sql
grant insert, select
on eventlog_import, heap_event, package
to ghc_perf;
;
grant usage
on eventlog_import_import_id_seq,
package_package_id_seq,
heap_event_heap_event_id_seq
to ghc_perf;
;
grant select
on eventlog_import, heap_event, package
to ghc_perf_web;
```
## Followup
Loading