pg_incremental

Overview

PIGSTY 3rd Party Extension: pg_incremental : Incremental Processing by Crunchy Data

Information

• Extension ID: 2880
• Extension Name: pg_incremental
• Package Name: pg_incremental
• Category: FEAT
• License: PostgreSQL
• Website: https://github.com/CrunchyData/pg_incremental
• Language: C
• Extra Tags: N/A
• Comment: N/A

Metadata

• Latest Version: 1.2.0
• Postgres Support: 17,16
• Need Load: Shared library do not need explicit loading
• Need DDL: Need CREATE EXTENSION DDL
• Relocatable: Can be installed into other schemas
• Trusted: Untrusted, Require Superuser to Create
• Schemas: pg_catalog
• Requires: pg_cron

RPM / DEB

• RPM Repo: PIGSTY
• RPM Name: pg_incremental_$v*
• RPM Ver : 1.2.0
• RPM Deps: pg_cron_$v
• DEB Repo: PIGSTY
• DEB Name: postgresql-$v-pg-incremental
• DEB Ver : 1.2.0
• DEB Deps: postgresql-$v-cron

Availability

Installation

Install pg_incremental via the pig CLI tool:

pig ext install pg_incremental

Install pg_incremental via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_incremental"]}' # -l <cls>

Install pg_incremental RPM from YUM repo directly:

dnf install pg_incremental_17*;
dnf install pg_incremental_16*;

Install pg_incremental DEB from APT repo directly:

apt install postgresql-17-pg-incremental;
apt install postgresql-16-pg-incremental;

Create pg_incremental extension on PostgreSQL cluster:

CREATE EXTENSION pg_incremental CASCADE;