pg_isok 0.1.3

This Release
pg_isok 0.1.3
Date
Status
Unstable
Latest Unstable
pg_isok 0.1.4 —
Other Releases
Abstract
A query centered monitoring tool
Description
Isok is for monitoring anything that can be reported with an SQL query. It lets you run SQL to produce reports alerting you of suspicious or erroneous conditions, with features to suppress previously reported alerts. Unlike simply running a query, which reports the existence of questionable data patterns, this method produces reports alerting you of changes to questionable data patterns, so that only new problems need be reviewed. Its expected usage targets data integrity maintenance and data cleanup. It is especially suited for corner cases where business logic is "fuzzy" and database content is monitored for unusual but not prohibited content. There is also a potential use-case for simplistic monitoring of PostgreSQL itself. Isok can be built as pure SQL, for installation in managed PostgreSQL instances. It targets PostgreSQL 10 or later.
Released By
kop
License
agpl_3
Resources
Special Files
Tags

Extensions

pg_isok 0.1.3
A query centered monitoring tool

Documentation

isok-The-Isok-Functions
The Isok Functions (Activating Isok)
The-SowkeDB-Acknowledgements
The SokweDB Acknowledgements
isok-Support-Tables
Isok Support Tables
Local-Copies-of-the-Documentation
B. Local Copies of the Documentation
cc0-Notice
Notice
cc0-Other-Information
Other Information
Acknowledgements-and-History
F. Acknowledgments and History
cc0-1.0-universal
J.  CC0 1.0 Universal
Mitigation-Strategies
Mitigation Strategies
appendix-Security-Considerations
A. Security Considerations
Isok-Overview
An Overview of the Isok Tables
What-Queries-Access-Matters
What Queries Access Matters
Isok-Licensing-Terms
G. Isok Licensing Terms -- Licensed Under The AGPL v3.0+ (Examples Excepted)
index
Isok -- A query centered monitoring tool for PostgreSQL
appendix-Techniques-For-Making-Local-Extensions-to-Isok
D. Techniques For Making Local Extensions to Isok
The-Search-Path
The Search Path
The-Gombe-Mother-Infant-Project-Acknowledgements
The Gombe Mother-Infant Project Acknowledgments
run_isok_queries
run_isok_queries
Building-and-Distributing
Building and Distributing
appendix-Periodic-Execution
C. Periodic Execution
agpl
H.  GNU Affero General Public License version 3
cc0-No-Copyright
No Copyright
Tool-Requirements
Tool Requirements
index
The Isok Documentation
Installation
Installation
The-Babase-Acknowledgements
The Babase Acknowledgments
Roles
Roles
Example-Periodic-Reporting-via-Email-Using-systemd
Example Periodic Reporting via Email Using systemd
Modify-Isoks-Generated-SQL
Modify Isok's Generated SQL
Isok-Main-Tables
The Isok Main Tables
Fully-Utilize-ISOK_RESULTS.QR_Extra
Fully Utilize ISOK_RESULTS.QR_Extra
CC0-1.0-Universal-Deed
I. CC0 1.0 Universal Deed
Wrap-run_isok_queries
Wrap run_isok_queries()
isok
Isok -- A query centered monitoring tool for PostgreSQL
Limiting-Access
Limiting Access
Creating-an-Audit-Trail
Creating an Audit Trail
extend-issue-classification
Extend Issue Classification
isok-introduction
Introduction to Isok
Developing-Isok
E. Developing Isok