pg_isok

pg_isok : Query-based data integrity management and soft alerting for PostgreSQL

Overview

Packages

Source

pig build pkg pg_isok;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_isok;		# install via package name, for the active PG version

pig install pg_isok -v 18;   # install for PG 18
pig install pg_isok -v 17;   # install for PG 17
pig install pg_isok -v 16;   # install for PG 16
pig install pg_isok -v 15;   # install for PG 15
pig install pg_isok -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION pg_isok;

Usage

• Source: Codeberg repo, documentation home, doc source
• Isok is a query-centered monitoring extension for PostgreSQL. It reports changes to previously seen questionable data patterns, not just the existence of the rows.

CREATE SCHEMA isok;
CREATE EXTENSION pg_isok SCHEMA isok;

Core Workflow

The extension centers on two tables:

• ISOK_QUERIES, which stores the monitoring queries
• ISOK_RESULTS, which stores the discovered issues and their resolution state

Run the monitor with run_isok_queries():

SELECT * FROM run_isok_queries();
SELECT * FROM run_isok_queries($$VALUES ('new_countries')$$) AS problems;

Rows in ISOK_RESULTS can be resolved or deferred so later runs no longer report them as active problems.

Notes

The documentation describes Isok as a “soft trigger” style tool for data cleanup and integrity review. It installs on PostgreSQL 10 or later and can be built as pure SQL for managed environments.