pg_accumulator

Accumulation registers for balance and turnover tracking in PostgreSQL

Overview

PackageVersionCategoryLicenseLanguage
pg_accumulator1.1.3FUNCPostgreSQLC
IDExtensionBinLibLoadCreateTrustRelocSchema
4845pg_accumulatorNoYesNoYesNoNoaccum
Relatedplpgsql financial topn quantile first_last_agg

Version

TypeRepoVersionPG VerPackageDeps
EXTPIGSTY1.1.31817161514pg_accumulatorplpgsql
RPMPIGSTY1.1.31817161514pg_accumulator_$v-
DEBPIGSTY1.1.31817161514postgresql-$v-pg-accumulator-
OS / PGPG18PG17PG16PG15PG14
el8.x86_64
el8.aarch64
el9.x86_64
el9.aarch64
el10.x86_64
el10.aarch64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
d12.x86_64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
d12.aarch64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
d13.x86_64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
d13.aarch64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
u22.x86_64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
u22.aarch64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
u24.x86_64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
u24.aarch64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
u26.x86_64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
u26.aarch64
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3
PIGSTY 1.1.3

Build

You can build the RPM / DEB packages for pg_accumulator using pig build:

pig build pkg pg_accumulator         # build RPM / DEB packages

Install

You can install pg_accumulator directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

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

Install the extension using pig or apt/yum/dnf:

pig install pg_accumulator;          # Install for current active PG version
pig ext install -y pg_accumulator -v 18  # PG 18
pig ext install -y pg_accumulator -v 17  # PG 17
pig ext install -y pg_accumulator -v 16  # PG 16
pig ext install -y pg_accumulator -v 15  # PG 15
pig ext install -y pg_accumulator -v 14  # PG 14
dnf install -y pg_accumulator_18       # PG 18
dnf install -y pg_accumulator_17       # PG 17
dnf install -y pg_accumulator_16       # PG 16
dnf install -y pg_accumulator_15       # PG 15
dnf install -y pg_accumulator_14       # PG 14
apt install -y postgresql-18-pg-accumulator   # PG 18
apt install -y postgresql-17-pg-accumulator   # PG 17
apt install -y postgresql-16-pg-accumulator   # PG 16
apt install -y postgresql-15-pg-accumulator   # PG 15
apt install -y postgresql-14-pg-accumulator   # PG 14

Create Extension:

CREATE EXTENSION pg_accumulator CASCADE;  -- requires: plpgsql

Last Modified 2026-05-01: update extension data (aaef844)