Check postgresql-version

Overview

Checks the installed PostgreSQL version against the endoflife.date API and alerts if the version is end-of-life or if newer major, minor, or patch releases are available. By default, alerts 30 days before the official EOL date. The offset is configurable.

Important Notes:

  • Must run on the PostgreSQL server itself

Data Collection:

  • Executes psql --username=<user> --command="SELECT version();" locally to determine the installed version

  • Queries the endoflife.date API to get the EOL date and latest available releases

  • Caches the API response in a local SQLite database to avoid excessive requests

Fact Sheet

Fact

Value

Check Plugin Download

https://github.com/Linuxfabrik/monitoring-plugins/tree/main/check-plugins/postgresql-version

Nagios/Icinga Check Name

check_postgresql_version

Check Interval Recommendation

Every day

Can be called without parameters

Yes

Runs on

Cross-platform

Compiled for Windows

No

Uses SQLite DBs

$TEMP/linuxfabrik-lib-version.db

Help

usage: postgresql-version [-h] [-V] [--always-ok] [--check-major]
                          [--check-minor] [--check-patch] [--insecure]
                          [--no-proxy] [--offset-eol OFFSET_EOL]
                          [--timeout TIMEOUT] [--test TEST]
                          [--username USERNAME]

Checks the installed PostgreSQL version against the endoflife.date API and
alerts if the version is end-of-life or if newer major, minor, or patch
releases are available. By default, alerts 30 days before the official EOL
date. The offset is configurable.

options:
  -h, --help            show this help message and exit
  -V, --version         show program's version number and exit
  --always-ok           Always returns OK.
  --check-major         Alert when a new major release is available, even if
                        the current version is not yet EOL. Example: running
                        v26 (not yet EOL) and v27 is available.
  --check-minor         Alert when a new major.minor release is available,
                        even if the current version is not yet EOL. Example:
                        running v26.2 (not yet EOL) and v26.3 is available.
  --check-patch         Alert when a new major.minor.patch release is
                        available, even if the current version is not yet EOL.
                        Example: running v26.2.7 (not yet EOL) and v26.2.8 is
                        available.
  --insecure            This option explicitly allows insecure SSL
                        connections.
  --no-proxy            Do not use a proxy.
  --offset-eol OFFSET_EOL
                        Alert n days before ("-30") or after an EOL date ("30"
                        or "+30"). Default: -30 days
  --timeout TIMEOUT     Network timeout in seconds. Default: 8 (seconds)
  --test TEST           For unit tests. Needs "path-to-stdout-file,path-to-
                        stderr-file,expected-retc".
  --username USERNAME   PostgreSQL username for running `psql`. Default:
                        postgres

Usage Examples

./postgresql-version --offset-eol=-30

Output:

PostgreSQL v10.16 (EOL 2022-11-10 -30d [WARNING], major 16.0 available, minor 10.23 available)

States

  • OK if the installed version is not EOL (considering the configured offset).

  • WARN if the installed version is EOL.

  • Optional: WARN when a new major version is available.

  • Optional: WARN when a new minor version is available.

  • Optional: WARN when a new patch version is available.

  • --always-ok suppresses all alerts and always returns OK.

Perfdata / Metrics

Name

Type

Description

postgresql-version

Number

Installed PostgreSQL version as float. „10.23“ becomes 10.23.

Credits, License