, a little green circle with a
down-pointing arrow, in the upper-right area of the page.)Isok is a PostgreSQL extension for monitoring anything that can be reported with an SQL query. Its expected usage targets data integrity maintenance and data cleanup. There is also a potential use-case for monitoring for errors in data, or even monitoring PostgreSQL itself.
Isok lets you run SQL to produce reports alerting you of suspicious or erroneous conditions. Specific rows in the reports can be deferred so they do not reappear before a designated date.
Isok can be built as pure SQL, for installation in the cloud or other managed PostgreSQL instances. Isok installs on PostgreSQL version 10 or later, although PostgreSQL versions no longer supported by The PostgreSQL Global Development Group may not get support.
Installation keeps a record of the Isok version and the build options used to construct it. See the above documentation.
The recommended download is from
the pg_isok page at
PGXN.org.
(Look for , a little green circle with a
down-pointing arrow, in the upper-right area of the page.)
It is possible, but not recommended, to build from source.
The source code repository is separate from documentation repository. You are currently looking at the part of the "Codeberg Pages" repository holding the Isok documentation.