This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: FEAT

FEAT: OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…

1: age
2: hll
3: rum
4: pg_graphql
5: pg_jsonschema
6: jsquery
7: pg_hint_plan
8: hypopg
9: index_advisor
10: plan_filter
11: imgsmlr
12: pg_ivm
13: pg_incremental
14: pgmq
15: pgq
16: pg_cardano
17: rdkit
18: omni
19: omni_auth
20: omni_aws
21: omni_cloudevents
22: omni_containers
23: omni_credentials
24: omni_email
25: omni_http
26: omni_httpc
27: omni_httpd
28: omni_id
29: omni_json
30: omni_kube
31: omni_ledger
32: omni_manifest
33: omni_mimetypes
34: omni_os
35: omni_polyfill
36: omni_python
37: omni_regex
38: omni_rest
39: omni_schema
40: omni_seq
41: omni_service
42: omni_session
43: omni_sql
44: omni_sqlite
45: omni_test
46: omni_txn
47: omni_types
48: omni_var
49: omni_vfs
50: omni_vfs_types_v1
51: omni_web
52: omni_worker
53: omni_xml
54: omni_yaml
55: bloom

FEAT category has 51 available extensions:

Name (Detail)	Package (Repo)	Repo	Version	Category	License	Description
age	`age`	MIXED	1.5.0	`FEAT`	Apache-2.0	AGE graph database extension
hll	`hll`	PGDG	2.18	`FEAT`	Apache-2.0	type for storing hyperloglog data
rum	`rum`	PGDG	1.3.14	`FEAT`	PostgreSQL	RUM index access method
pg_graphql	`pg_graphql`	PIGSTY	1.5.11	`FEAT`	Apache-2.0	pg_graphql: GraphQL support
pg_jsonschema	`pg_jsonschema`	PIGSTY	0.3.3	`FEAT`	Apache-2.0	PostgreSQL extension providing JSON Schema validation
jsquery	`jsquery`	PGDG	1.2	`FEAT`	PostgreSQL	data type for jsonb inspection
pg_hint_plan	`pg_hint_plan`	PGDG	1.7.0	`FEAT`	BSD 3	Give PostgreSQL ability to manually force some decisions in execution plans.
hypopg	`hypopg`	PGDG	1.4.1	`FEAT`	PostgreSQL	Hypothetical indexes for PostgreSQL
index_advisor	`index_advisor`	PIGSTY	0.2.0	`FEAT`	PostgreSQL	Query index advisor
plan_filter	`pg_plan_filter`	PIGSTY	0.0.1	`FEAT`	PostgreSQL	filter statements by their execution plans.
imgsmlr	`imgsmlr`	PIGSTY	1.0	`FEAT`	PostgreSQL	Image similarity with haar
pg_ivm	`pg_ivm`	MIXED	1.10	`FEAT`	PostgreSQL	incremental view maintenance on PostgreSQL
pg_incremental	`pg_incremental`	PIGSTY	1.2.0	`FEAT`	PostgreSQL	Incremental Processing by Crunchy Data
pgmq	`pgmq`	PIGSTY	1.5.0	`FEAT`	PostgreSQL	A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgq	`pgq`	PGDG	3.5.1	`FEAT`	ISC	Generic queue for PostgreSQL
pg_cardano	`pg_cardano`	PIGSTY	1.0.3	`FEAT`	MIT	A suite of Cardano-related tools
rdkit	`rdkit`	PGDG	202409.4	`FEAT`	BSD 3	Cheminformatics functionality for PostgreSQL.
omni	`omnigres`	PIGSTY	0.2.4	`FEAT`	Apache-2.0	Advanced adapter for Postgres extensions
omni_auth	`omnigres`	PIGSTY	0.1.2	`FEAT`	Apache-2.0	Basic session management
omni_aws	`omnigres`	PIGSTY	0.1.2	`FEAT`	Apache-2.0	Amazon Web Services APIs (S3)
omni_containers	`omnigres`	PIGSTY	0.2.0	`FEAT`	Apache-2.0	Docker container management
omni_credentials	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	Application credential management
omni_http	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	Basic HTTP types
omni_httpc	`omnigres`	PIGSTY	0.1.4	`FEAT`	Apache-2.0	HTTP client
omni_httpd	`omnigres`	PIGSTY	0.2.9	`FEAT`	Apache-2.0	HTTP server
omni_id	`omnigres`	PIGSTY	0.4.0	`FEAT`	Apache-2.0	Identity types
omni_json	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	JSON toolkit
omni_kube	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	Kubernetes (k8s) integration
omni_ledger	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	Financial ledger
omni_manifest	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	Package installation manifests
omni_mimetypes	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	MIME types
omni_os	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	Operating system integration
omni_polyfill	`omnigres`	PIGSTY	0.2.0	`FEAT`	Apache-2.0	Postgres API polyfills
omni_python	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	First-class Python support
omni_regex	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	PCRE-compatible regular expressions
omni_rest	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	REST API toolkit (with PostgREST support)
omni_schema	`omnigres`	PIGSTY	0.2.3	`FEAT`	Apache-2.0	Advanced schema management tooling
omni_seq	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	Distributed integer sequences
omni_service	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	Service management
omni_session	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	Session management
omni_sql	`omnigres`	PIGSTY	0.5.0	`FEAT`	Apache-2.0	Programmatic SQL manipulation
omni_test	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	Testing framework
omni_txn	`omnigres`	PIGSTY	0.5.0	`FEAT`	Apache-2.0	Transaction management
omni_types	`omnigres`	PIGSTY	0.2.1	`FEAT`	Apache-2.0	Advanced types
omni_var	`omnigres`	PIGSTY	0.3.0	`FEAT`	Apache-2.0	Scoped variables
omni_vfs	`omnigres`	PIGSTY	0.2.0	`FEAT`	Apache-2.0	Virtual File System
omni_vfs_types_v1	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	Virtual File System types (v1)
omni_web	`omnigres`	PIGSTY	0.1.1	`FEAT`	Apache-2.0	Common web stack primitives
omni_xml	`omnigres`	PIGSTY	0.1.2	`FEAT`	Apache-2.0	XML toolkit
omni_yaml	`omnigres`	PIGSTY	0.1.0	`FEAT`	Apache-2.0	YAML toolkit
bloom	`bloom`	CONTRIB	1.0	`FEAT`	PostgreSQL	bloom access method - signature file based index

1 - age

AGE graph database extension

Overview

MIXED 3rd Party Extension: age : AGE graph database extension

Information

Extension ID: 2760
Extension Name: age
Package Name: age
Category: FEAT
License: Apache-2.0
Website: https://github.com/apache/age
Language: C
Extra Tags: N/A
Comment:

Metadata

Latest Version: 1.5.0
Postgres Support: 17,16,15,14,13
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: ag_catalog
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: apache-age_$v*
RPM Ver : 1.5.0
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-age
DEB Ver : 1.5.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`apache-age_17` PIGSTY 1.5.0	`apache-age_16` PIGSTY 1.5.0	`apache-age_15` PIGSTY 1.5.0	`apache-age_14` PIGSTY 1.5.0	`apache-age_13` PIGSTY 1.5.0
`el8`	`aarch64`	`apache-age_17` PIGSTY 1.5.0	`apache-age_16` PIGSTY 1.5.0	`apache-age_15` PIGSTY 1.5.0	`apache-age_14` PIGSTY 1.5.0	`apache-age_13` PIGSTY 1.5.0
`el9`	`x86_64`	`apache-age_17` PIGSTY 1.5.0	`apache-age_16` PIGSTY 1.5.0	`apache-age_15` PIGSTY 1.5.0	`apache-age_14` PIGSTY 1.5.0	`apache-age_13` PIGSTY 1.5.0
`el9`	`aarch64`	`apache-age_17` PIGSTY 1.5.0	`apache-age_16` PIGSTY 1.5.0	`apache-age_15` PIGSTY 1.5.0	`apache-age_14` PIGSTY 1.5.0	`apache-age_13` PIGSTY 1.5.0
`d12`	`x86_64`	`postgresql-17-age` PGDG 1.5.0~rc0	`postgresql-16-age` PGDG 1.5.0~rc0	`postgresql-15-age` PGDG 1.5.0~rc0	`postgresql-14-age` PGDG 1.5.0~rc0	`postgresql-13-age` PGDG 1.5.0~rc0
`d12`	`aarch64`	`postgresql-17-age` PGDG 1.5.0~rc0	`postgresql-16-age` PGDG 1.5.0~rc0	`postgresql-15-age` PGDG 1.5.0~rc0	`postgresql-14-age` PGDG 1.5.0~rc0	`postgresql-13-age` PGDG 1.5.0~rc0
`u22`	`x86_64`	`postgresql-17-age` PGDG 1.5.0~rc0	`postgresql-16-age` PGDG 1.5.0~rc0	`postgresql-15-age` PGDG 1.5.0~rc0	`postgresql-14-age` PGDG 1.5.0~rc0	`postgresql-13-age` PGDG 1.5.0~rc0
`u22`	`aarch64`	`postgresql-17-age` PGDG 1.5.0~rc0	`postgresql-16-age` PGDG 1.5.0~rc0	`postgresql-15-age` PGDG 1.5.0~rc0	`postgresql-14-age` PGDG 1.5.0~rc0	`postgresql-13-age` PGDG 1.5.0~rc0
`u24`	`x86_64`	`postgresql-17-age` PGDG 1.5.0~rc0	`postgresql-16-age` PGDG 1.5.0~rc0	`postgresql-15-age` PGDG 1.5.0~rc0	`postgresql-14-age` PGDG 1.5.0~rc0	`postgresql-13-age` PGDG 1.5.0~rc0
`u24`	`aarch64`	`postgresql-17-age` PGDG 1.5.0~rc0	`postgresql-16-age` PGDG 1.5.0~rc0	`postgresql-15-age` PGDG 1.5.0~rc0	`postgresql-14-age` PGDG 1.5.0~rc0	`postgresql-13-age` PGDG 1.5.0~rc0

Installation

Install age via the pig CLI tool:

pig ext install age

Install age via Pigsty playbook:

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

Install age RPM from YUM repo directly:

dnf install apache-age_17*;
dnf install apache-age_16*;
dnf install apache-age_15*;
dnf install apache-age_14*;
dnf install apache-age_13*;

Install age DEB from APT repo directly:

apt install postgresql-17-age;
apt install postgresql-16-age;
apt install postgresql-15-age;
apt install postgresql-14-age;
apt install postgresql-13-age;

Create age extension on PostgreSQL cluster:

CREATE EXTENSION age;

2 - hll

type for storing hyperloglog data

Overview

PGDG 1st Party Extension: hll : type for storing hyperloglog data

Information

Extension ID: 2770
Extension Name: hll
Package Name: hll
Category: FEAT
License: Apache-2.0
Website: https://github.com/citusdata/postgresql-hll
Language: C++
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 2.18
Postgres Support: 17,16,15,14,13
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: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: hll_$v*
RPM Ver : 2.18
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-hll
DEB Ver : 2.18
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`hll_17` PGDG 2.18	`hll_16` PGDG 2.18	`hll_15` PGDG 2.18	`hll_14` PGDG 2.18	`hll_13` PGDG 2.18
`el8`	`aarch64`	`hll_17` PGDG 2.18	`hll_16` PGDG 2.18	`hll_15` PGDG 2.18	`hll_14` PGDG 2.18	`hll_13` PGDG 2.18
`el9`	`x86_64`	`hll_17` PGDG 2.18	`hll_16` PGDG 2.18	`hll_15` PGDG 2.18	`hll_14` PGDG 2.18	`hll_13` PGDG 2.18
`el9`	`aarch64`	`hll_17` PGDG 2.18	`hll_16` PGDG 2.18	`hll_15` PGDG 2.18	`hll_14` PGDG 2.18	`hll_13` PGDG 2.18
`d12`	`x86_64`	`postgresql-17-hll` PGDG 2.18	`postgresql-16-hll` PGDG 2.18	`postgresql-15-hll` PGDG 2.18	`postgresql-14-hll` PGDG 2.18	`postgresql-13-hll` PGDG 2.18
`d12`	`aarch64`	`postgresql-17-hll` PGDG 2.18	`postgresql-16-hll` PGDG 2.18	`postgresql-15-hll` PGDG 2.18	`postgresql-14-hll` PGDG 2.18	`postgresql-13-hll` PGDG 2.18
`u22`	`x86_64`	`postgresql-17-hll` PGDG 2.18	`postgresql-16-hll` PGDG 2.18	`postgresql-15-hll` PGDG 2.18	`postgresql-14-hll` PGDG 2.18	`postgresql-13-hll` PGDG 2.18
`u22`	`aarch64`	`postgresql-17-hll` PGDG 2.18	`postgresql-16-hll` PGDG 2.18	`postgresql-15-hll` PGDG 2.18	`postgresql-14-hll` PGDG 2.18	`postgresql-13-hll` PGDG 2.18
`u24`	`x86_64`	`postgresql-17-hll` PGDG 2.18	`postgresql-16-hll` PGDG 2.18	`postgresql-15-hll` PGDG 2.18	`postgresql-14-hll` PGDG 2.18	`postgresql-13-hll` PGDG 2.18
`u24`	`aarch64`	`postgresql-17-hll` PGDG 2.18	`postgresql-16-hll` PGDG 2.18	`postgresql-15-hll` PGDG 2.18	`postgresql-14-hll` PGDG 2.18	`postgresql-13-hll` PGDG 2.18

Installation

Install hll via the pig CLI tool:

pig ext install hll

Install hll via Pigsty playbook:

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

Install hll RPM from YUM repo directly:

dnf install hll_17*;
dnf install hll_16*;
dnf install hll_15*;
dnf install hll_14*;
dnf install hll_13*;

Install hll DEB from APT repo directly:

apt install postgresql-17-hll;
apt install postgresql-16-hll;
apt install postgresql-15-hll;
apt install postgresql-14-hll;
apt install postgresql-13-hll;

Create hll extension on PostgreSQL cluster:

CREATE EXTENSION hll;

3 - rum

RUM index access method

Overview

PGDG 1st Party Extension: rum : RUM index access method

Information

Extension ID: 2780
Extension Name: rum
Package Name: rum
Category: FEAT
License: PostgreSQL
Website: https://github.com/postgrespro/rum
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.3.14
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: rum_$v
RPM Ver : 1.3
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-rum
DEB Ver : 1.3
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`rum_17` PGDG 1.3.14	`rum_16` PGDG 1.3.14	`rum_15` PGDG 1.3.14	`rum_14` PGDG 1.3.14	`rum_13` PGDG 1.3.14
`el8`	`aarch64`	`rum_17` PGDG 1.3.14	`rum_16` PGDG 1.3.14	`rum_15` PGDG 1.3.14	`rum_14` PGDG 1.3.14	`rum_13` PGDG 1.3.14
`el9`	`x86_64`	`rum_17` PGDG 1.3.14	`rum_16` PGDG 1.3.14	`rum_15` PGDG 1.3.14	`rum_14` PGDG 1.3.14	`rum_13` PGDG 1.3.14
`el9`	`aarch64`	`rum_17` PGDG 1.3.14	`rum_16` PGDG 1.3.14	`rum_15` PGDG 1.3.14	`rum_14` PGDG 1.3.14	`rum_13` PGDG 1.3.14
`d12`	`x86_64`	`postgresql-17-rum` PGDG 1.3.14	`postgresql-16-rum` PGDG 1.3.14	`postgresql-15-rum` PGDG 1.3.14	`postgresql-14-rum` PGDG 1.3.14	`postgresql-13-rum` PGDG 1.3.14
`d12`	`aarch64`	`postgresql-17-rum` PGDG 1.3.14	`postgresql-16-rum` PGDG 1.3.14	`postgresql-15-rum` PGDG 1.3.14	`postgresql-14-rum` PGDG 1.3.14	`postgresql-13-rum` PGDG 1.3.14
`u22`	`x86_64`	`postgresql-17-rum` PGDG 1.3.14	`postgresql-16-rum` PGDG 1.3.14	`postgresql-15-rum` PGDG 1.3.14	`postgresql-14-rum` PGDG 1.3.14	`postgresql-13-rum` PGDG 1.3.14
`u22`	`aarch64`	`postgresql-17-rum` PGDG 1.3.14	`postgresql-16-rum` PGDG 1.3.14	`postgresql-15-rum` PGDG 1.3.14	`postgresql-14-rum` PGDG 1.3.14	`postgresql-13-rum` PGDG 1.3.14
`u24`	`x86_64`	`postgresql-17-rum` PGDG 1.3.14	`postgresql-16-rum` PGDG 1.3.14	`postgresql-15-rum` PGDG 1.3.14	`postgresql-14-rum` PGDG 1.3.14	`postgresql-13-rum` PGDG 1.3.14
`u24`	`aarch64`	`postgresql-17-rum` PGDG 1.3.14	`postgresql-16-rum` PGDG 1.3.14	`postgresql-15-rum` PGDG 1.3.14	`postgresql-14-rum` PGDG 1.3.14	`postgresql-13-rum` PGDG 1.3.14

Installation

Install rum via the pig CLI tool:

pig ext install rum

Install rum via Pigsty playbook:

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

Install rum RPM from YUM repo directly:

dnf install rum_17;
dnf install rum_16;
dnf install rum_15;
dnf install rum_14;
dnf install rum_13;

Install rum DEB from APT repo directly:

apt install postgresql-17-rum;
apt install postgresql-16-rum;
apt install postgresql-15-rum;
apt install postgresql-14-rum;
apt install postgresql-13-rum;

Create rum extension on PostgreSQL cluster:

CREATE EXTENSION rum;

4 - pg_graphql

pg_graphql: GraphQL support

Overview

PIGSTY 3rd Party Extension: pg_graphql : pg_graphql: GraphQL support

Information

Extension ID: 2790
Extension Name: pg_graphql
Package Name: pg_graphql
Category: FEAT
License: Apache-2.0
Website: https://github.com/supabase/pg_graphql
Language: Rust
Extra Tags: pgrx, supabase
Comment:

Metadata

Latest Version: 1.5.11
Postgres Support: 17,16,15,14
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: graphql
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_graphql_$v
RPM Ver : 1.5.11
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-graphql
DEB Ver : 1.5.11
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14
`el8`	`x86_64`	`pg_graphql_17` PIGSTY 1.5.11	`pg_graphql_16` PIGSTY 1.5.11	`pg_graphql_15` PIGSTY 1.5.11	`pg_graphql_14` PIGSTY 1.5.11
`el8`	`aarch64`	`pg_graphql_17` PIGSTY 1.5.11	`pg_graphql_16` PIGSTY 1.5.11	`pg_graphql_15` PIGSTY 1.5.11	`pg_graphql_14` PIGSTY 1.5.11
`el9`	`x86_64`	`pg_graphql_17` PIGSTY 1.5.11	`pg_graphql_16` PIGSTY 1.5.11	`pg_graphql_15` PIGSTY 1.5.11	`pg_graphql_14` PIGSTY 1.5.11
`el9`	`aarch64`	`pg_graphql_17` PIGSTY 1.5.11	`pg_graphql_16` PIGSTY 1.5.11	`pg_graphql_15` PIGSTY 1.5.11	`pg_graphql_14` PIGSTY 1.5.11
`d12`	`x86_64`	`postgresql-17-pg-graphql` PIGSTY 1.5.11	`postgresql-16-pg-graphql` PIGSTY 1.5.11	`postgresql-15-pg-graphql` PIGSTY 1.5.11	`postgresql-14-pg-graphql` PIGSTY 1.5.11
`d12`	`aarch64`	`postgresql-17-pg-graphql` PIGSTY 1.5.11	`postgresql-16-pg-graphql` PIGSTY 1.5.11	`postgresql-15-pg-graphql` PIGSTY 1.5.11	`postgresql-14-pg-graphql` PIGSTY 1.5.11
`u22`	`x86_64`	`postgresql-17-pg-graphql` PIGSTY 1.5.11	`postgresql-16-pg-graphql` PIGSTY 1.5.11	`postgresql-15-pg-graphql` PIGSTY 1.5.11	`postgresql-14-pg-graphql` PIGSTY 1.5.11
`u22`	`aarch64`	`postgresql-17-pg-graphql` PIGSTY 1.5.11	`postgresql-16-pg-graphql` PIGSTY 1.5.11	`postgresql-15-pg-graphql` PIGSTY 1.5.11	`postgresql-14-pg-graphql` PIGSTY 1.5.11
`u24`	`x86_64`	`postgresql-17-pg-graphql` PIGSTY 1.5.11	`postgresql-16-pg-graphql` PIGSTY 1.5.11	`postgresql-15-pg-graphql` PIGSTY 1.5.11	`postgresql-14-pg-graphql` PIGSTY 1.5.11
`u24`	`aarch64`	`postgresql-17-pg-graphql` PIGSTY 1.5.11	`postgresql-16-pg-graphql` PIGSTY 1.5.11	`postgresql-15-pg-graphql` PIGSTY 1.5.11	`postgresql-14-pg-graphql` PIGSTY 1.5.11

Installation

Install pg_graphql via the pig CLI tool:

pig ext install pg_graphql

Install pg_graphql via Pigsty playbook:

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

Install pg_graphql RPM from YUM repo directly:

dnf install pg_graphql_17;
dnf install pg_graphql_16;
dnf install pg_graphql_15;
dnf install pg_graphql_14;

Install pg_graphql DEB from APT repo directly:

apt install postgresql-17-pg-graphql;
apt install postgresql-16-pg-graphql;
apt install postgresql-15-pg-graphql;
apt install postgresql-14-pg-graphql;

Create pg_graphql extension on PostgreSQL cluster:

CREATE EXTENSION pg_graphql;

5 - pg_jsonschema

PostgreSQL extension providing JSON Schema validation

Overview

PIGSTY 3rd Party Extension: pg_jsonschema : PostgreSQL extension providing JSON Schema validation

Information

Extension ID: 2800
Extension Name: pg_jsonschema
Package Name: pg_jsonschema
Category: FEAT
License: Apache-2.0
Website: https://github.com/supabase/pg_jsonschema
Language: Rust
Extra Tags: pgrx, supabase
Comment:

Metadata

Latest Version: 0.3.3
Postgres Support: 17,16,15,14,13
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: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_jsonschema_$v
RPM Ver : 0.3.3
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-jsonschema
DEB Ver : 0.3.3
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_jsonschema_17` PIGSTY 0.3.3	`pg_jsonschema_16` PIGSTY 0.3.3	`pg_jsonschema_15` PIGSTY 0.3.3	`pg_jsonschema_14` PIGSTY 0.3.3	`pg_jsonschema_13` PIGSTY 0.3.3
`el8`	`aarch64`	`pg_jsonschema_17` PIGSTY 0.3.3	`pg_jsonschema_16` PIGSTY 0.3.3	`pg_jsonschema_15` PIGSTY 0.3.3	`pg_jsonschema_14` PIGSTY 0.3.3	`pg_jsonschema_13` PIGSTY 0.3.3
`el9`	`x86_64`	`pg_jsonschema_17` PIGSTY 0.3.3	`pg_jsonschema_16` PIGSTY 0.3.3	`pg_jsonschema_15` PIGSTY 0.3.3	`pg_jsonschema_14` PIGSTY 0.3.3	`pg_jsonschema_13` PIGSTY 0.3.3
`el9`	`aarch64`	`pg_jsonschema_17` PIGSTY 0.3.3	`pg_jsonschema_16` PIGSTY 0.3.3	`pg_jsonschema_15` PIGSTY 0.3.3	`pg_jsonschema_14` PIGSTY 0.3.3	`pg_jsonschema_13` PIGSTY 0.3.3
`d12`	`x86_64`	`postgresql-17-pg-jsonschema` PIGSTY 0.3.3	`postgresql-16-pg-jsonschema` PIGSTY 0.3.3	`postgresql-15-pg-jsonschema` PIGSTY 0.3.3	`postgresql-14-pg-jsonschema` PIGSTY 0.3.3	`postgresql-13-pg-jsonschema` PIGSTY 0.3.3
`d12`	`aarch64`	`postgresql-17-pg-jsonschema` PIGSTY 0.3.3	`postgresql-16-pg-jsonschema` PIGSTY 0.3.3	`postgresql-15-pg-jsonschema` PIGSTY 0.3.3	`postgresql-14-pg-jsonschema` PIGSTY 0.3.3	`postgresql-13-pg-jsonschema` PIGSTY 0.3.3
`u22`	`x86_64`	`postgresql-17-pg-jsonschema` PIGSTY 0.3.3	`postgresql-16-pg-jsonschema` PIGSTY 0.3.3	`postgresql-15-pg-jsonschema` PIGSTY 0.3.3	`postgresql-14-pg-jsonschema` PIGSTY 0.3.3	`postgresql-13-pg-jsonschema` PIGSTY 0.3.3
`u22`	`aarch64`	`postgresql-17-pg-jsonschema` PIGSTY 0.3.3	`postgresql-16-pg-jsonschema` PIGSTY 0.3.3	`postgresql-15-pg-jsonschema` PIGSTY 0.3.3	`postgresql-14-pg-jsonschema` PIGSTY 0.3.3	`postgresql-13-pg-jsonschema` PIGSTY 0.3.3
`u24`	`x86_64`	`postgresql-17-pg-jsonschema` PIGSTY 0.3.3	`postgresql-16-pg-jsonschema` PIGSTY 0.3.3	`postgresql-15-pg-jsonschema` PIGSTY 0.3.3	`postgresql-14-pg-jsonschema` PIGSTY 0.3.3	`postgresql-13-pg-jsonschema` PIGSTY 0.3.3
`u24`	`aarch64`	`postgresql-17-pg-jsonschema` PIGSTY 0.3.3	`postgresql-16-pg-jsonschema` PIGSTY 0.3.3	`postgresql-15-pg-jsonschema` PIGSTY 0.3.3	`postgresql-14-pg-jsonschema` PIGSTY 0.3.3	`postgresql-13-pg-jsonschema` PIGSTY 0.3.3

Installation

Install pg_jsonschema via the pig CLI tool:

pig ext install pg_jsonschema

Install pg_jsonschema via Pigsty playbook:

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

Install pg_jsonschema RPM from YUM repo directly:

dnf install pg_jsonschema_17;
dnf install pg_jsonschema_16;
dnf install pg_jsonschema_15;
dnf install pg_jsonschema_14;
dnf install pg_jsonschema_13;

Install pg_jsonschema DEB from APT repo directly:

apt install postgresql-17-pg-jsonschema;
apt install postgresql-16-pg-jsonschema;
apt install postgresql-15-pg-jsonschema;
apt install postgresql-14-pg-jsonschema;
apt install postgresql-13-pg-jsonschema;

Create pg_jsonschema extension on PostgreSQL cluster:

CREATE EXTENSION pg_jsonschema;

6 - jsquery

data type for jsonb inspection

Overview

PGDG 1st Party Extension: jsquery : data type for jsonb inspection

Information

Extension ID: 2810
Extension Name: jsquery
Package Name: jsquery
Category: FEAT
License: PostgreSQL
Website: https://github.com/postgrespro/jsquery
Language: C
Extra Tags: N/A
Comment:

Metadata

Latest Version: 1.2
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: jsquery_$v*
RPM Ver : 1.2
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-jsquery
DEB Ver : 1.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`jsquery_17` PGDG 1.2	`jsquery_16` PGDG 1.2	`jsquery_15` PGDG 1.2	`jsquery_14` PGDG 1.2	`jsquery_13` PGDG 1.1.1
`el8`	`aarch64`	`jsquery_17` PGDG 1.2	`jsquery_16` PGDG 1.2	`jsquery_15` PGDG 1.2	`jsquery_14` PGDG 1.2	`jsquery_13` PGDG 1.1.1
`el9`	`x86_64`	`jsquery_17` PGDG 1.2	`jsquery_16` PGDG 1.2	`jsquery_15` PGDG 1.2	`jsquery_14` PGDG 1.2
`el9`	`aarch64`	`jsquery_17` PGDG 1.2	`jsquery_16` PGDG 1.2	`jsquery_15` PGDG 1.2	`jsquery_14` PGDG 1.2	`jsquery_13` PGDG 1.1.1
`d12`	`x86_64`	`postgresql-17-jsquery` PGDG 1.2	`postgresql-16-jsquery` PGDG 1.2	`postgresql-15-jsquery` PGDG 1.2	`postgresql-14-jsquery` PGDG 1.2	`postgresql-13-jsquery` PGDG 1.2
`d12`	`aarch64`	`postgresql-17-jsquery` PGDG 1.2	`postgresql-16-jsquery` PGDG 1.2	`postgresql-15-jsquery` PGDG 1.2	`postgresql-14-jsquery` PGDG 1.2	`postgresql-13-jsquery` PGDG 1.2
`u22`	`x86_64`	`postgresql-17-jsquery` PGDG 1.2	`postgresql-16-jsquery` PGDG 1.2	`postgresql-15-jsquery` PGDG 1.2	`postgresql-14-jsquery` PGDG 1.2	`postgresql-13-jsquery` PGDG 1.2
`u22`	`aarch64`	`postgresql-17-jsquery` PGDG 1.2	`postgresql-16-jsquery` PGDG 1.2	`postgresql-15-jsquery` PGDG 1.2	`postgresql-14-jsquery` PGDG 1.2	`postgresql-13-jsquery` PGDG 1.2
`u24`	`x86_64`	`postgresql-17-jsquery` PGDG 1.2	`postgresql-16-jsquery` PGDG 1.2	`postgresql-15-jsquery` PGDG 1.2	`postgresql-14-jsquery` PGDG 1.2	`postgresql-13-jsquery` PGDG 1.2
`u24`	`aarch64`	`postgresql-17-jsquery` PGDG 1.2	`postgresql-16-jsquery` PGDG 1.2	`postgresql-15-jsquery` PGDG 1.2	`postgresql-14-jsquery` PGDG 1.2	`postgresql-13-jsquery` PGDG 1.2

Installation

Install jsquery via the pig CLI tool:

pig ext install jsquery

Install jsquery via Pigsty playbook:

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

Install jsquery RPM from YUM repo directly:

dnf install jsquery_17*;
dnf install jsquery_16*;
dnf install jsquery_15*;
dnf install jsquery_14*;

Install jsquery DEB from APT repo directly:

apt install postgresql-17-jsquery;
apt install postgresql-16-jsquery;
apt install postgresql-15-jsquery;
apt install postgresql-14-jsquery;
apt install postgresql-13-jsquery;

Create jsquery extension on PostgreSQL cluster:

CREATE EXTENSION jsquery;

7 - pg_hint_plan

Give PostgreSQL ability to manually force some decisions in execution plans.

Overview

PGDG 1st Party Extension: pg_hint_plan : Give PostgreSQL ability to manually force some decisions in execution plans.

Information

Extension ID: 2820
Extension Name: pg_hint_plan
Package Name: pg_hint_plan
Category: FEAT
License: BSD 3
Website: https://github.com/ossc-db/pg_hint_plan
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.7.0
Postgres Support: 17,16,15,14,13
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: hint_plan
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: pg_hint_plan_$v*
RPM Ver : 1.7.0
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-pg-hint-plan
DEB Ver : 1.7.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_hint_plan_17` PGDG 1.7.0	`pg_hint_plan_16` PGDG 1.6.1	`pg_hint_plan_15` PGDG 1.5.2	`pg_hint_plan_14` PGDG 1.4.3	`pg_hint_plan_13` PGDG 1.3.10
`el8`	`aarch64`	`pg_hint_plan_17` PGDG 1.7.0	`pg_hint_plan_16` PGDG 1.6.1	`pg_hint_plan_15` PGDG 1.5.2	`pg_hint_plan_14` PGDG 1.4.3	`pg_hint_plan_13` PGDG 1.3.10
`el9`	`x86_64`	`pg_hint_plan_17` PGDG 1.7.0	`pg_hint_plan_16` PGDG 1.6.1	`pg_hint_plan_15` PGDG 1.5.2	`pg_hint_plan_14` PGDG 1.4.3	`pg_hint_plan_13` PGDG 1.3.10
`el9`	`aarch64`	`pg_hint_plan_17` PGDG 1.7.0	`pg_hint_plan_16` PGDG 1.6.1	`pg_hint_plan_15` PGDG 1.5.2	`pg_hint_plan_14` PGDG 1.4.3	`pg_hint_plan_13` PGDG 1.3.10
`d12`	`x86_64`	`postgresql-17-pg-hint-plan` PGDG 1.7.0	`postgresql-16-pg-hint-plan` PGDG 1.6.1	`postgresql-15-pg-hint-plan` PGDG 1.5.2	`postgresql-14-pg-hint-plan` PGDG 1.4.3	`postgresql-13-pg-hint-plan` PGDG 1.3.10
`d12`	`aarch64`	`postgresql-17-pg-hint-plan` PGDG 1.7.0	`postgresql-16-pg-hint-plan` PGDG 1.6.1	`postgresql-15-pg-hint-plan` PGDG 1.5.2	`postgresql-14-pg-hint-plan` PGDG 1.4.3	`postgresql-13-pg-hint-plan` PGDG 1.3.10
`u22`	`x86_64`	`postgresql-17-pg-hint-plan` PGDG 1.7.0	`postgresql-16-pg-hint-plan` PGDG 1.6.1	`postgresql-15-pg-hint-plan` PGDG 1.5.2	`postgresql-14-pg-hint-plan` PGDG 1.4.3	`postgresql-13-pg-hint-plan` PGDG 1.3.10
`u22`	`aarch64`	`postgresql-17-pg-hint-plan` PGDG 1.7.0	`postgresql-16-pg-hint-plan` PGDG 1.6.1	`postgresql-15-pg-hint-plan` PGDG 1.5.2	`postgresql-14-pg-hint-plan` PGDG 1.4.3	`postgresql-13-pg-hint-plan` PGDG 1.3.10
`u24`	`x86_64`	`postgresql-17-pg-hint-plan` PGDG 1.7.0	`postgresql-16-pg-hint-plan` PGDG 1.6.1	`postgresql-15-pg-hint-plan` PGDG 1.5.2	`postgresql-14-pg-hint-plan` PGDG 1.4.3	`postgresql-13-pg-hint-plan` PGDG 1.3.10
`u24`	`aarch64`	`postgresql-17-pg-hint-plan` PGDG 1.7.0	`postgresql-16-pg-hint-plan` PGDG 1.6.1	`postgresql-15-pg-hint-plan` PGDG 1.5.2	`postgresql-14-pg-hint-plan` PGDG 1.4.3	`postgresql-13-pg-hint-plan` PGDG 1.3.10

Installation

Install pg_hint_plan via the pig CLI tool:

pig ext install pg_hint_plan

Install pg_hint_plan via Pigsty playbook:

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

Install pg_hint_plan RPM from YUM repo directly:

dnf install pg_hint_plan_17*;
dnf install pg_hint_plan_16*;
dnf install pg_hint_plan_15*;
dnf install pg_hint_plan_14*;
dnf install pg_hint_plan_13*;

Install pg_hint_plan DEB from APT repo directly:

apt install postgresql-17-pg-hint-plan;
apt install postgresql-16-pg-hint-plan;
apt install postgresql-15-pg-hint-plan;
apt install postgresql-14-pg-hint-plan;
apt install postgresql-13-pg-hint-plan;

Create pg_hint_plan extension on PostgreSQL cluster:

CREATE EXTENSION pg_hint_plan;

8 - hypopg

Hypothetical indexes for PostgreSQL

Overview

PGDG 1st Party Extension: hypopg : Hypothetical indexes for PostgreSQL

Information

Extension ID: 2830
Extension Name: hypopg
Package Name: hypopg
Category: FEAT
License: PostgreSQL
Website: https://github.com/HypoPG/hypopg
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.4.1
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: hypopg_$v*
RPM Ver : 1.4.1
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-hypopg
DEB Ver : 1.4.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`hypopg_17` PGDG 1.4.1	`hypopg_16` PGDG 1.4.1	`hypopg_15` PGDG 1.4.1	`hypopg_14` PGDG 1.4.1	`hypopg_13` PGDG 1.4.1
`el8`	`aarch64`	`hypopg_17` PGDG 1.4.1	`hypopg_16` PGDG 1.4.1	`hypopg_15` PGDG 1.4.1	`hypopg_14` PGDG 1.4.1	`hypopg_13` PGDG 1.4.1
`el9`	`x86_64`	`hypopg_17` PGDG 1.4.1	`hypopg_16` PGDG 1.4.1	`hypopg_15` PGDG 1.4.1	`hypopg_14` PGDG 1.4.1	`hypopg_13` PGDG 1.4.1
`el9`	`aarch64`	`hypopg_17` PGDG 1.4.1	`hypopg_16` PGDG 1.4.1	`hypopg_15` PGDG 1.4.1	`hypopg_14` PGDG 1.4.1	`hypopg_13` PGDG 1.4.1
`d12`	`x86_64`	`postgresql-17-hypopg` PGDG 1.4.1	`postgresql-16-hypopg` PGDG 1.4.1	`postgresql-15-hypopg` PGDG 1.4.1	`postgresql-14-hypopg` PGDG 1.4.1	`postgresql-13-hypopg` PGDG 1.4.1
`d12`	`aarch64`	`postgresql-17-hypopg` PGDG 1.4.1	`postgresql-16-hypopg` PGDG 1.4.1	`postgresql-15-hypopg` PGDG 1.4.1	`postgresql-14-hypopg` PGDG 1.4.1	`postgresql-13-hypopg` PGDG 1.4.1
`u22`	`x86_64`	`postgresql-17-hypopg` PGDG 1.4.1	`postgresql-16-hypopg` PGDG 1.4.1	`postgresql-15-hypopg` PGDG 1.4.1	`postgresql-14-hypopg` PGDG 1.4.1	`postgresql-13-hypopg` PGDG 1.4.1
`u22`	`aarch64`	`postgresql-17-hypopg` PGDG 1.4.1	`postgresql-16-hypopg` PGDG 1.4.1	`postgresql-15-hypopg` PGDG 1.4.1	`postgresql-14-hypopg` PGDG 1.4.1	`postgresql-13-hypopg` PGDG 1.4.1
`u24`	`x86_64`	`postgresql-17-hypopg` PGDG 1.4.1	`postgresql-16-hypopg` PGDG 1.4.1	`postgresql-15-hypopg` PGDG 1.4.1	`postgresql-14-hypopg` PGDG 1.4.1	`postgresql-13-hypopg` PGDG 1.4.1
`u24`	`aarch64`	`postgresql-17-hypopg` PGDG 1.4.1	`postgresql-16-hypopg` PGDG 1.4.1	`postgresql-15-hypopg` PGDG 1.4.1	`postgresql-14-hypopg` PGDG 1.4.1	`postgresql-13-hypopg` PGDG 1.4.1

Installation

Install hypopg via the pig CLI tool:

pig ext install hypopg

Install hypopg via Pigsty playbook:

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

Install hypopg RPM from YUM repo directly:

dnf install hypopg_17*;
dnf install hypopg_16*;
dnf install hypopg_15*;
dnf install hypopg_14*;
dnf install hypopg_13*;

Install hypopg DEB from APT repo directly:

apt install postgresql-17-hypopg;
apt install postgresql-16-hypopg;
apt install postgresql-15-hypopg;
apt install postgresql-14-hypopg;
apt install postgresql-13-hypopg;

Create hypopg extension on PostgreSQL cluster:

CREATE EXTENSION hypopg;

9 - index_advisor

Query index advisor

Overview

PIGSTY 3rd Party Extension: index_advisor : Query index advisor

Information

Extension ID: 2840
Extension Name: index_advisor
Package Name: index_advisor
Category: FEAT
License: PostgreSQL
Website: https://github.com/supabase/index_advisor
Language: SQL
Extra Tags: supabase
Comment: N/A

Metadata

Latest Version: 0.2.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Unknown
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: index_advisor_$v
RPM Ver : 0.2.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-index-advisor
DEB Ver : 0.2.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`index_advisor_17` PIGSTY 0.2.0	`index_advisor_16` PIGSTY 0.2.0	`index_advisor_15` PIGSTY 0.2.0	`index_advisor_14` PIGSTY 0.2.0	`index_advisor_13` PIGSTY 0.2.0
`el8`	`aarch64`	`index_advisor_17` PIGSTY 0.2.0	`index_advisor_16` PIGSTY 0.2.0	`index_advisor_15` PIGSTY 0.2.0	`index_advisor_14` PIGSTY 0.2.0	`index_advisor_13` PIGSTY 0.2.0
`el9`	`x86_64`	`index_advisor_17` PIGSTY 0.2.0	`index_advisor_16` PIGSTY 0.2.0	`index_advisor_15` PIGSTY 0.2.0	`index_advisor_14` PIGSTY 0.2.0	`index_advisor_13` PIGSTY 0.2.0
`el9`	`aarch64`	`index_advisor_17` PIGSTY 0.2.0	`index_advisor_16` PIGSTY 0.2.0	`index_advisor_15` PIGSTY 0.2.0	`index_advisor_14` PIGSTY 0.2.0	`index_advisor_13` PIGSTY 0.2.0
`d12`	`x86_64`	`postgresql-17-index-advisor` PIGSTY 0.2.0	`postgresql-16-index-advisor` PIGSTY 0.2.0	`postgresql-15-index-advisor` PIGSTY 0.2.0	`postgresql-14-index-advisor` PIGSTY 0.2.0	`postgresql-13-index-advisor` PIGSTY 0.2.0
`d12`	`aarch64`	`postgresql-17-index-advisor` PIGSTY 0.2.0	`postgresql-16-index-advisor` PIGSTY 0.2.0	`postgresql-15-index-advisor` PIGSTY 0.2.0	`postgresql-14-index-advisor` PIGSTY 0.2.0	`postgresql-13-index-advisor` PIGSTY 0.2.0
`u22`	`x86_64`	`postgresql-17-index-advisor` PIGSTY 0.2.0	`postgresql-16-index-advisor` PIGSTY 0.2.0	`postgresql-15-index-advisor` PIGSTY 0.2.0	`postgresql-14-index-advisor` PIGSTY 0.2.0	`postgresql-13-index-advisor` PIGSTY 0.2.0
`u22`	`aarch64`	`postgresql-17-index-advisor` PIGSTY 0.2.0	`postgresql-16-index-advisor` PIGSTY 0.2.0	`postgresql-15-index-advisor` PIGSTY 0.2.0	`postgresql-14-index-advisor` PIGSTY 0.2.0	`postgresql-13-index-advisor` PIGSTY 0.2.0
`u24`	`x86_64`	`postgresql-17-index-advisor` PIGSTY 0.2.0	`postgresql-16-index-advisor` PIGSTY 0.2.0	`postgresql-15-index-advisor` PIGSTY 0.2.0	`postgresql-14-index-advisor` PIGSTY 0.2.0	`postgresql-13-index-advisor` PIGSTY 0.2.0
`u24`	`aarch64`	`postgresql-17-index-advisor` PIGSTY 0.2.0	`postgresql-16-index-advisor` PIGSTY 0.2.0	`postgresql-15-index-advisor` PIGSTY 0.2.0	`postgresql-14-index-advisor` PIGSTY 0.2.0	`postgresql-13-index-advisor` PIGSTY 0.2.0

Installation

Install index_advisor via the pig CLI tool:

pig ext install index_advisor

Install index_advisor via Pigsty playbook:

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

Install index_advisor RPM from YUM repo directly:

dnf install index_advisor_17;
dnf install index_advisor_16;
dnf install index_advisor_15;
dnf install index_advisor_14;
dnf install index_advisor_13;

Install index_advisor DEB from APT repo directly:

apt install postgresql-17-index-advisor;
apt install postgresql-16-index-advisor;
apt install postgresql-15-index-advisor;
apt install postgresql-14-index-advisor;
apt install postgresql-13-index-advisor;

Create index_advisor extension on PostgreSQL cluster:

CREATE EXTENSION index_advisor;

10 - plan_filter

filter statements by their execution plans.

Overview

PIGSTY 3rd Party Extension: pg_plan_filter : filter statements by their execution plans.

Information

Extension ID: 2850
Extension Name: plan_filter
Package Name: pg_plan_filter
Category: FEAT
License: PostgreSQL
Website: https://github.com/pgexperts/pg_plan_filter
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.0.1
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Dd not need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_plan_filter_$v*
RPM Ver : 0.0.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-plan-filter
DEB Ver : 0.0.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_plan_filter_17` PIGSTY 0.0.1	`pg_plan_filter_16` PIGSTY 0.0.1	`pg_plan_filter_15` PIGSTY 0.0.1	`pg_plan_filter_14` PIGSTY 0.0.1	`pg_plan_filter_13` PIGSTY 0.0.1
`el8`	`aarch64`	`pg_plan_filter_17` PIGSTY 0.0.1	`pg_plan_filter_16` PIGSTY 0.0.1	`pg_plan_filter_15` PIGSTY 0.0.1	`pg_plan_filter_14` PIGSTY 0.0.1	`pg_plan_filter_13` PIGSTY 0.0.1
`el9`	`x86_64`	`pg_plan_filter_17` PIGSTY 0.0.1	`pg_plan_filter_16` PIGSTY 0.0.1	`pg_plan_filter_15` PIGSTY 0.0.1	`pg_plan_filter_14` PIGSTY 0.0.1	`pg_plan_filter_13` PIGSTY 0.0.1
`el9`	`aarch64`	`pg_plan_filter_17` PIGSTY 0.0.1	`pg_plan_filter_16` PIGSTY 0.0.1	`pg_plan_filter_15` PIGSTY 0.0.1	`pg_plan_filter_14` PIGSTY 0.0.1	`pg_plan_filter_13` PIGSTY 0.0.1
`d12`	`x86_64`	`postgresql-17-pg-plan-filter` PIGSTY 0.0.1	`postgresql-16-pg-plan-filter` PIGSTY 0.0.1	`postgresql-15-pg-plan-filter` PIGSTY 0.0.1	`postgresql-14-pg-plan-filter` PIGSTY 0.0.1	`postgresql-13-pg-plan-filter` PIGSTY 0.0.1
`d12`	`aarch64`	`postgresql-17-pg-plan-filter` PIGSTY 0.0.1	`postgresql-16-pg-plan-filter` PIGSTY 0.0.1	`postgresql-15-pg-plan-filter` PIGSTY 0.0.1	`postgresql-14-pg-plan-filter` PIGSTY 0.0.1	`postgresql-13-pg-plan-filter` PIGSTY 0.0.1
`u22`	`x86_64`	`postgresql-17-pg-plan-filter` PIGSTY 0.0.1	`postgresql-16-pg-plan-filter` PIGSTY 0.0.1	`postgresql-15-pg-plan-filter` PIGSTY 0.0.1	`postgresql-14-pg-plan-filter` PIGSTY 0.0.1	`postgresql-13-pg-plan-filter` PIGSTY 0.0.1
`u22`	`aarch64`	`postgresql-17-pg-plan-filter` PIGSTY 0.0.1	`postgresql-16-pg-plan-filter` PIGSTY 0.0.1	`postgresql-15-pg-plan-filter` PIGSTY 0.0.1	`postgresql-14-pg-plan-filter` PIGSTY 0.0.1	`postgresql-13-pg-plan-filter` PIGSTY 0.0.1
`u24`	`x86_64`	`postgresql-17-pg-plan-filter` PIGSTY 0.0.1	`postgresql-16-pg-plan-filter` PIGSTY 0.0.1	`postgresql-15-pg-plan-filter` PIGSTY 0.0.1	`postgresql-14-pg-plan-filter` PIGSTY 0.0.1	`postgresql-13-pg-plan-filter` PIGSTY 0.0.1
`u24`	`aarch64`	`postgresql-17-pg-plan-filter` PIGSTY 0.0.1	`postgresql-16-pg-plan-filter` PIGSTY 0.0.1	`postgresql-15-pg-plan-filter` PIGSTY 0.0.1	`postgresql-14-pg-plan-filter` PIGSTY 0.0.1	`postgresql-13-pg-plan-filter` PIGSTY 0.0.1

Installation

Install plan_filter via the pig CLI tool:


pig ext install pg_plan_filter; 	# Extension Name
pig ext install plan_filter; 	# normalized package name

Install pg_plan_filter via Pigsty playbook:

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

Install pg_plan_filter RPM from YUM repo directly:

dnf install pg_plan_filter_17*;
dnf install pg_plan_filter_16*;
dnf install pg_plan_filter_15*;
dnf install pg_plan_filter_14*;
dnf install pg_plan_filter_13*;

Install pg_plan_filter DEB from APT repo directly:

apt install postgresql-17-pg-plan-filter;
apt install postgresql-16-pg-plan-filter;
apt install postgresql-15-pg-plan-filter;
apt install postgresql-14-pg-plan-filter;
apt install postgresql-13-pg-plan-filter;

Extension plan_filter has to be loaded via shared_preload_libraries

shared_preload_libraries = 'plan_filter'; # add to pg cluster config

Extension %s does not need CREATE EXTENSION command

11 - imgsmlr

Image similarity with haar

Overview

PIGSTY 3rd Party Extension: imgsmlr : Image similarity with haar

Information

Extension ID: 2860
Extension Name: imgsmlr
Package Name: imgsmlr
Category: FEAT
License: PostgreSQL
Website: https://github.com/postgrespro/imgsmlr
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: imgsmlr_$v*
RPM Ver : 1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-imgsmlr
DEB Ver : 1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`imgsmlr_17` PIGSTY 1.0	`imgsmlr_16` PIGSTY 1.0	`imgsmlr_15` PIGSTY 1.0	`imgsmlr_14` PIGSTY 1.0	`imgsmlr_13` PIGSTY 1.0
`el8`	`aarch64`	`imgsmlr_17` PIGSTY 1.0	`imgsmlr_16` PIGSTY 1.0	`imgsmlr_15` PIGSTY 1.0	`imgsmlr_14` PIGSTY 1.0	`imgsmlr_13` PIGSTY 1.0
`el9`	`x86_64`	`imgsmlr_17` PIGSTY 1.0	`imgsmlr_16` PIGSTY 1.0	`imgsmlr_15` PIGSTY 1.0	`imgsmlr_14` PIGSTY 1.0	`imgsmlr_13` PIGSTY 1.0
`el9`	`aarch64`	`imgsmlr_17` PIGSTY 1.0	`imgsmlr_16` PIGSTY 1.0	`imgsmlr_15` PIGSTY 1.0	`imgsmlr_14` PIGSTY 1.0	`imgsmlr_13` PIGSTY 1.0
`d12`	`x86_64`	`postgresql-17-imgsmlr` PIGSTY 1.0	`postgresql-16-imgsmlr` PIGSTY 1.0	`postgresql-15-imgsmlr` PIGSTY 1.0	`postgresql-14-imgsmlr` PIGSTY 1.0	`postgresql-13-imgsmlr` PIGSTY 1.0
`d12`	`aarch64`	`postgresql-17-imgsmlr` PIGSTY 1.0	`postgresql-16-imgsmlr` PIGSTY 1.0	`postgresql-15-imgsmlr` PIGSTY 1.0	`postgresql-14-imgsmlr` PIGSTY 1.0	`postgresql-13-imgsmlr` PIGSTY 1.0
`u22`	`x86_64`	`postgresql-17-imgsmlr` PIGSTY 1.0	`postgresql-16-imgsmlr` PIGSTY 1.0	`postgresql-15-imgsmlr` PIGSTY 1.0	`postgresql-14-imgsmlr` PIGSTY 1.0	`postgresql-13-imgsmlr` PIGSTY 1.0
`u22`	`aarch64`	`postgresql-17-imgsmlr` PIGSTY 1.0	`postgresql-16-imgsmlr` PIGSTY 1.0	`postgresql-15-imgsmlr` PIGSTY 1.0	`postgresql-14-imgsmlr` PIGSTY 1.0	`postgresql-13-imgsmlr` PIGSTY 1.0
`u24`	`x86_64`	`postgresql-17-imgsmlr` PIGSTY 1.0	`postgresql-16-imgsmlr` PIGSTY 1.0	`postgresql-15-imgsmlr` PIGSTY 1.0	`postgresql-14-imgsmlr` PIGSTY 1.0	`postgresql-13-imgsmlr` PIGSTY 1.0
`u24`	`aarch64`	`postgresql-17-imgsmlr` PIGSTY 1.0	`postgresql-16-imgsmlr` PIGSTY 1.0	`postgresql-15-imgsmlr` PIGSTY 1.0	`postgresql-14-imgsmlr` PIGSTY 1.0	`postgresql-13-imgsmlr` PIGSTY 1.0

Installation

Install imgsmlr via the pig CLI tool:

pig ext install imgsmlr

Install imgsmlr via Pigsty playbook:

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

Install imgsmlr RPM from YUM repo directly:

dnf install imgsmlr_17*;
dnf install imgsmlr_16*;
dnf install imgsmlr_15*;
dnf install imgsmlr_14*;
dnf install imgsmlr_13*;

Install imgsmlr DEB from APT repo directly:

apt install postgresql-17-imgsmlr;
apt install postgresql-16-imgsmlr;
apt install postgresql-15-imgsmlr;
apt install postgresql-14-imgsmlr;
apt install postgresql-13-imgsmlr;

Create imgsmlr extension on PostgreSQL cluster:

CREATE EXTENSION imgsmlr;

12 - pg_ivm

incremental view maintenance on PostgreSQL

Overview

MIXED 3rd Party Extension: pg_ivm : incremental view maintenance on PostgreSQL

Information

Extension ID: 2870
Extension Name: pg_ivm
Package Name: pg_ivm
Category: FEAT
License: PostgreSQL
Website: https://github.com/sraoss/pg_ivm
Language: C
Extra Tags: N/A
Comment:

Metadata

Latest Version: 1.11
Postgres Support: 17,16,15,14,13
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: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: pg_ivm_$v*
RPM Ver : 1.11
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-ivm
DEB Ver : 1.11
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_ivm_17` PGDG 1.11	`pg_ivm_16` PGDG 1.11	`pg_ivm_15` PGDG 1.11	`pg_ivm_14` PGDG 1.11	`pg_ivm_13` PGDG 1.11
`el8`	`aarch64`	`pg_ivm_17` PGDG 1.11	`pg_ivm_16` PGDG 1.11	`pg_ivm_15` PGDG 1.11	`pg_ivm_14` PGDG 1.11	`pg_ivm_13` PGDG 1.11
`el9`	`x86_64`	`pg_ivm_17` PGDG 1.11	`pg_ivm_16` PGDG 1.11	`pg_ivm_15` PGDG 1.11	`pg_ivm_14` PGDG 1.11	`pg_ivm_13` PGDG 1.11
`el9`	`aarch64`	`pg_ivm_17` PGDG 1.11	`pg_ivm_16` PGDG 1.11	`pg_ivm_15` PGDG 1.11	`pg_ivm_14` PGDG 1.11	`pg_ivm_13` PGDG 1.11
`d12`	`x86_64`	`postgresql-17-pg-ivm` PIGSTY 1.11	`postgresql-16-pg-ivm` PIGSTY 1.11	`postgresql-15-pg-ivm` PIGSTY 1.11	`postgresql-14-pg-ivm` PIGSTY 1.11	`postgresql-13-pg-ivm` PIGSTY 1.11
`d12`	`aarch64`	`postgresql-17-pg-ivm` PIGSTY 1.11	`postgresql-16-pg-ivm` PIGSTY 1.11	`postgresql-15-pg-ivm` PIGSTY 1.11	`postgresql-14-pg-ivm` PIGSTY 1.11	`postgresql-13-pg-ivm` PIGSTY 1.11
`u22`	`x86_64`	`postgresql-17-pg-ivm` PIGSTY 1.11	`postgresql-16-pg-ivm` PIGSTY 1.11	`postgresql-15-pg-ivm` PIGSTY 1.11	`postgresql-14-pg-ivm` PIGSTY 1.11	`postgresql-13-pg-ivm` PIGSTY 1.11
`u22`	`aarch64`	`postgresql-17-pg-ivm` PIGSTY 1.11	`postgresql-16-pg-ivm` PIGSTY 1.11	`postgresql-15-pg-ivm` PIGSTY 1.11	`postgresql-14-pg-ivm` PIGSTY 1.11	`postgresql-13-pg-ivm` PIGSTY 1.11
`u24`	`x86_64`	`postgresql-17-pg-ivm` PIGSTY 1.11	`postgresql-16-pg-ivm` PIGSTY 1.11	`postgresql-15-pg-ivm` PIGSTY 1.11	`postgresql-14-pg-ivm` PIGSTY 1.11	`postgresql-13-pg-ivm` PIGSTY 1.11
`u24`	`aarch64`	`postgresql-17-pg-ivm` PIGSTY 1.11	`postgresql-16-pg-ivm` PIGSTY 1.11	`postgresql-15-pg-ivm` PIGSTY 1.11	`postgresql-14-pg-ivm` PIGSTY 1.11	`postgresql-13-pg-ivm` PIGSTY 1.11

Installation

Install pg_ivm via the pig CLI tool:

pig ext install pg_ivm

Install pg_ivm via Pigsty playbook:

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

Install pg_ivm RPM from YUM repo directly:

dnf install pg_ivm_17*;
dnf install pg_ivm_16*;
dnf install pg_ivm_15*;
dnf install pg_ivm_14*;
dnf install pg_ivm_13*;

Install pg_ivm DEB from APT repo directly:

apt install postgresql-17-pg-ivm;
apt install postgresql-16-pg-ivm;
apt install postgresql-15-pg-ivm;
apt install postgresql-14-pg-ivm;
apt install postgresql-13-pg-ivm;

Create pg_ivm extension on PostgreSQL cluster:

CREATE EXTENSION pg_ivm;

13 - pg_incremental

Incremental Processing by Crunchy Data

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

OS	Arch	PG17	PG16
`el8`	`x86_64`	`pg_incremental_17` PIGSTY 1.2.0	`pg_incremental_16` PIGSTY 1.2.0
`el8`	`aarch64`	`pg_incremental_17` PIGSTY 1.2.0	`pg_incremental_16` PIGSTY 1.2.0
`el9`	`x86_64`	`pg_incremental_17` PIGSTY 1.2.0	`pg_incremental_16` PIGSTY 1.2.0
`el9`	`aarch64`	`pg_incremental_17` PIGSTY 1.2.0	`pg_incremental_16` PIGSTY 1.2.0
`d12`	`x86_64`	`postgresql-17-pg-incremental` PIGSTY 1.2.0	`postgresql-16-pg-incremental` PIGSTY 1.2.0
`d12`	`aarch64`	`postgresql-17-pg-incremental` PIGSTY 1.2.0	`postgresql-16-pg-incremental` PIGSTY 1.2.0
`u22`	`x86_64`	`postgresql-17-pg-incremental` PIGSTY 1.2.0	`postgresql-16-pg-incremental` PIGSTY 1.2.0
`u22`	`aarch64`	`postgresql-17-pg-incremental` PIGSTY 1.2.0	`postgresql-16-pg-incremental` PIGSTY 1.2.0
`u24`	`x86_64`	`postgresql-17-pg-incremental` PIGSTY 1.2.0	`postgresql-16-pg-incremental` PIGSTY 1.2.0
`u24`	`aarch64`	`postgresql-17-pg-incremental` PIGSTY 1.2.0	`postgresql-16-pg-incremental` PIGSTY 1.2.0

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;

14 - pgmq

A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

Overview

PIGSTY 3rd Party Extension: pgmq : A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

Information

Extension ID: 2900
Extension Name: pgmq
Package Name: pgmq
Category: FEAT
License: PostgreSQL
Website: https://github.com/pgmq/pgmq
Language: SQL
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.5.1
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: pgmq
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pgmq_$v
RPM Ver : 1.5.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgmq
DEB Ver : 1.5.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgmq_17` PIGSTY 1.5.1	`pgmq_16` PIGSTY 1.5.1	`pgmq_15` PIGSTY 1.5.1	`pgmq_14` PIGSTY 1.5.1	`pgmq_13` PIGSTY 1.5.1
`el8`	`aarch64`	`pgmq_17` PIGSTY 1.5.1	`pgmq_16` PIGSTY 1.5.1	`pgmq_15` PIGSTY 1.5.1	`pgmq_14` PIGSTY 1.5.1	`pgmq_13` PIGSTY 1.5.1
`el9`	`x86_64`	`pgmq_17` PIGSTY 1.5.1	`pgmq_16` PIGSTY 1.5.1	`pgmq_15` PIGSTY 1.5.1	`pgmq_14` PIGSTY 1.5.1	`pgmq_13` PIGSTY 1.5.1
`el9`	`aarch64`	`pgmq_17` PIGSTY 1.5.1	`pgmq_16` PIGSTY 1.5.1	`pgmq_15` PIGSTY 1.5.1	`pgmq_14` PIGSTY 1.5.1	`pgmq_13` PIGSTY 1.5.1
`d12`	`x86_64`	`postgresql-17-pgmq` PIGSTY 1.5.1	`postgresql-16-pgmq` PIGSTY 1.5.1	`postgresql-15-pgmq` PIGSTY 1.5.1	`postgresql-14-pgmq` PIGSTY 1.5.1	`postgresql-13-pgmq` PIGSTY 1.5.1
`d12`	`aarch64`	`postgresql-17-pgmq` PIGSTY 1.5.1	`postgresql-16-pgmq` PIGSTY 1.5.1	`postgresql-15-pgmq` PIGSTY 1.5.1	`postgresql-14-pgmq` PIGSTY 1.5.1	`postgresql-13-pgmq` PIGSTY 1.5.1
`u22`	`x86_64`	`postgresql-17-pgmq` PIGSTY 1.5.1	`postgresql-16-pgmq` PIGSTY 1.5.1	`postgresql-15-pgmq` PIGSTY 1.5.1	`postgresql-14-pgmq` PIGSTY 1.5.1	`postgresql-13-pgmq` PIGSTY 1.5.1
`u22`	`aarch64`	`postgresql-17-pgmq` PIGSTY 1.5.1	`postgresql-16-pgmq` PIGSTY 1.5.1	`postgresql-15-pgmq` PIGSTY 1.5.1	`postgresql-14-pgmq` PIGSTY 1.5.1	`postgresql-13-pgmq` PIGSTY 1.5.1
`u24`	`x86_64`	`postgresql-17-pgmq` PIGSTY 1.5.1	`postgresql-16-pgmq` PIGSTY 1.5.1	`postgresql-15-pgmq` PIGSTY 1.5.1	`postgresql-14-pgmq` PIGSTY 1.5.1	`postgresql-13-pgmq` PIGSTY 1.5.1
`u24`	`aarch64`	`postgresql-17-pgmq` PIGSTY 1.5.1	`postgresql-16-pgmq` PIGSTY 1.5.1	`postgresql-15-pgmq` PIGSTY 1.5.1	`postgresql-14-pgmq` PIGSTY 1.5.1	`postgresql-13-pgmq` PIGSTY 1.5.1

Installation

Install pgmq via the pig CLI tool:

pig ext install pgmq

Install pgmq via Pigsty playbook:

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

Install pgmq RPM from YUM repo directly:

dnf install pgmq_17;
dnf install pgmq_16;
dnf install pgmq_15;
dnf install pgmq_14;
dnf install pgmq_13;

Install pgmq DEB from APT repo directly:

apt install postgresql-17-pgmq;
apt install postgresql-16-pgmq;
apt install postgresql-15-pgmq;
apt install postgresql-14-pgmq;
apt install postgresql-13-pgmq;

Create pgmq extension on PostgreSQL cluster:

CREATE EXTENSION pgmq;

15 - pgq

Generic queue for PostgreSQL

Overview

PGDG 1st Party Extension: pgq : Generic queue for PostgreSQL

Information

Extension ID: 2910
Extension Name: pgq
Package Name: pgq
Category: FEAT
License: ISC
Website: https://github.com/pgq/pgq
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 3.5.1
Postgres Support: 17,16,15,14,13
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: N/A

RPM / DEB

RPM Repo: PGDG
RPM Name: pgq_$v*
RPM Ver : 3.5.1
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-pgq3
DEB Ver : 3.5
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pgq_17` PGDG 3.5.1	`pgq_16` PGDG 3.5.1	`pgq_15` PGDG 3.5.1	`pgq_14` PGDG 3.5.1	`pgq_13` PGDG 3.5.1
`el8`	`aarch64`	`pgq_17` PGDG 3.5.1	`pgq_16` PGDG 3.5.1	`pgq_15` PGDG 3.5.1	`pgq_14` PGDG 3.5.1	`pgq_13` PGDG 3.5.1
`el9`	`x86_64`	`pgq_17` PGDG 3.5.1	`pgq_16` PGDG 3.5.1	`pgq_15` PGDG 3.5.1	`pgq_14` PGDG 3.5.1	`pgq_13` PGDG 3.5.1
`el9`	`aarch64`	`pgq_17` PGDG 3.5.1	`pgq_16` PGDG 3.5.1	`pgq_15` PGDG 3.5.1	`pgq_14` PGDG 3.5.1	`pgq_13` PGDG 3.5.1
`d12`	`x86_64`	`postgresql-17-pgq3` PGDG 3.5.1	`postgresql-16-pgq3` PGDG 3.5.1	`postgresql-15-pgq3` PGDG 3.5.1	`postgresql-14-pgq3` PGDG 3.5.1	`postgresql-13-pgq3` PGDG 3.5.1
`d12`	`aarch64`	`postgresql-17-pgq3` PGDG 3.5.1	`postgresql-16-pgq3` PGDG 3.5.1	`postgresql-15-pgq3` PGDG 3.5.1	`postgresql-14-pgq3` PGDG 3.5.1	`postgresql-13-pgq3` PGDG 3.5.1
`u22`	`x86_64`	`postgresql-17-pgq3` PGDG 3.5.1	`postgresql-16-pgq3` PGDG 3.5.1	`postgresql-15-pgq3` PGDG 3.5.1	`postgresql-14-pgq3` PGDG 3.5.1	`postgresql-13-pgq3` PGDG 3.5.1
`u22`	`aarch64`	`postgresql-17-pgq3` PGDG 3.5.1	`postgresql-16-pgq3` PGDG 3.5.1	`postgresql-15-pgq3` PGDG 3.5.1	`postgresql-14-pgq3` PGDG 3.5.1	`postgresql-13-pgq3` PGDG 3.5.1
`u24`	`x86_64`	`postgresql-17-pgq3` PGDG 3.5.1	`postgresql-16-pgq3` PGDG 3.5.1	`postgresql-15-pgq3` PGDG 3.5.1	`postgresql-14-pgq3` PGDG 3.5.1	`postgresql-13-pgq3` PGDG 3.5.1
`u24`	`aarch64`	`postgresql-17-pgq3` PGDG 3.5.1	`postgresql-16-pgq3` PGDG 3.5.1	`postgresql-15-pgq3` PGDG 3.5.1	`postgresql-14-pgq3` PGDG 3.5.1	`postgresql-13-pgq3` PGDG 3.5.1

Installation

Install pgq via the pig CLI tool:

pig ext install pgq

Install pgq via Pigsty playbook:

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

Install pgq RPM from YUM repo directly:

dnf install pgq_17*;
dnf install pgq_16*;
dnf install pgq_15*;
dnf install pgq_14*;
dnf install pgq_13*;

Install pgq DEB from APT repo directly:

apt install postgresql-17-pgq3;
apt install postgresql-16-pgq3;
apt install postgresql-15-pgq3;
apt install postgresql-14-pgq3;
apt install postgresql-13-pgq3;

Create pgq extension on PostgreSQL cluster:

CREATE EXTENSION pgq;

16 - pg_cardano

A suite of Cardano-related tools

Overview

PIGSTY 3rd Party Extension: pg_cardano : A suite of Cardano-related tools

Information

Extension ID: 2930
Extension Name: pg_cardano
Package Name: pg_cardano
Category: FEAT
License: MIT
Website: https://github.com/Fell-x27/pg_cardano
Language: Rust
Extra Tags: pgrx
Comment:

Metadata

Latest Version: 1.0.5
Postgres Support: 17,16,15,14,13
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: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: pg_cardano_$v
RPM Ver : 1.0.5
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-cardano
DEB Ver : 1.0.5
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`pg_cardano_17` PIGSTY 1.0.5	`pg_cardano_16` PIGSTY 1.0.5	`pg_cardano_15` PIGSTY 1.0.5	`pg_cardano_14` PIGSTY 1.0.5	`pg_cardano_13` PIGSTY 1.0.5
`el8`	`aarch64`	`pg_cardano_17` PIGSTY 1.0.5	`pg_cardano_16` PIGSTY 1.0.5	`pg_cardano_15` PIGSTY 1.0.5	`pg_cardano_14` PIGSTY 1.0.5	`pg_cardano_13` PIGSTY 1.0.5
`el9`	`x86_64`	`pg_cardano_17` PIGSTY 1.0.5	`pg_cardano_16` PIGSTY 1.0.5	`pg_cardano_15` PIGSTY 1.0.5	`pg_cardano_14` PIGSTY 1.0.5	`pg_cardano_13` PIGSTY 1.0.5
`el9`	`aarch64`	`pg_cardano_17` PIGSTY 1.0.5	`pg_cardano_16` PIGSTY 1.0.5	`pg_cardano_15` PIGSTY 1.0.5	`pg_cardano_14` PIGSTY 1.0.5	`pg_cardano_13` PIGSTY 1.0.5
`d12`	`x86_64`	`postgresql-17-pg-cardano` PIGSTY 1.0.5	`postgresql-16-pg-cardano` PIGSTY 1.0.5	`postgresql-15-pg-cardano` PIGSTY 1.0.5	`postgresql-14-pg-cardano` PIGSTY 1.0.5	`postgresql-13-pg-cardano` PIGSTY 1.0.5
`d12`	`aarch64`	`postgresql-17-pg-cardano` PIGSTY 1.0.5	`postgresql-16-pg-cardano` PIGSTY 1.0.5	`postgresql-15-pg-cardano` PIGSTY 1.0.5	`postgresql-14-pg-cardano` PIGSTY 1.0.5	`postgresql-13-pg-cardano` PIGSTY 1.0.5
`u22`	`x86_64`	`postgresql-17-pg-cardano` PIGSTY 1.0.5	`postgresql-16-pg-cardano` PIGSTY 1.0.5	`postgresql-15-pg-cardano` PIGSTY 1.0.5	`postgresql-14-pg-cardano` PIGSTY 1.0.5	`postgresql-13-pg-cardano` PIGSTY 1.0.5
`u22`	`aarch64`	`postgresql-17-pg-cardano` PIGSTY 1.0.5	`postgresql-16-pg-cardano` PIGSTY 1.0.5	`postgresql-15-pg-cardano` PIGSTY 1.0.5	`postgresql-14-pg-cardano` PIGSTY 1.0.5	`postgresql-13-pg-cardano` PIGSTY 1.0.5
`u24`	`x86_64`	`postgresql-17-pg-cardano` PIGSTY 1.0.5	`postgresql-16-pg-cardano` PIGSTY 1.0.5	`postgresql-15-pg-cardano` PIGSTY 1.0.5	`postgresql-14-pg-cardano` PIGSTY 1.0.5	`postgresql-13-pg-cardano` PIGSTY 1.0.5
`u24`	`aarch64`	`postgresql-17-pg-cardano` PIGSTY 1.0.5	`postgresql-16-pg-cardano` PIGSTY 1.0.5	`postgresql-15-pg-cardano` PIGSTY 1.0.5	`postgresql-14-pg-cardano` PIGSTY 1.0.5	`postgresql-13-pg-cardano` PIGSTY 1.0.5

Installation

Install pg_cardano via the pig CLI tool:

pig ext install pg_cardano

Install pg_cardano via Pigsty playbook:

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

Install pg_cardano RPM from YUM repo directly:

dnf install pg_cardano_17;
dnf install pg_cardano_16;
dnf install pg_cardano_15;
dnf install pg_cardano_14;
dnf install pg_cardano_13;

Install pg_cardano DEB from APT repo directly:

apt install postgresql-17-pg-cardano;
apt install postgresql-16-pg-cardano;
apt install postgresql-15-pg-cardano;
apt install postgresql-14-pg-cardano;
apt install postgresql-13-pg-cardano;

Create pg_cardano extension on PostgreSQL cluster:

CREATE EXTENSION pg_cardano;

17 - rdkit

Cheminformatics functionality for PostgreSQL.

Overview

PGDG 1st Party Extension: rdkit : Cheminformatics functionality for PostgreSQL.

Information

Extension ID: 2940
Extension Name: rdkit
Package Name: rdkit
Category: FEAT
License: BSD 3
Website: https://github.com/rdkit/rdkit
Language: C++
Extra Tags: N/A
Comment:

Metadata

Latest Version: 202409.4
Postgres Support: 16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: None
RPM Name: N/A
RPM Ver : N/A
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-rdkit
DEB Ver : 202409.4
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`
`el8`	`aarch64`
`el9`	`x86_64`
`el9`	`aarch64`
`d12`	`x86_64`		`postgresql-16-rdkit` PGDG 202303.3	`postgresql-15-rdkit` PGDG 202303.3	`postgresql-14-rdkit` PGDG 202303.3	`postgresql-13-rdkit` PGDG 202303.3
`d12`	`aarch64`		`postgresql-16-rdkit` PGDG 202303.3	`postgresql-15-rdkit` PGDG 202303.3	`postgresql-14-rdkit` PGDG 202303.3	`postgresql-13-rdkit` PGDG 202303.3
`u22`	`x86_64`		`postgresql-16-rdkit` PGDG 202303.3	`postgresql-15-rdkit` PGDG 202303.3	`postgresql-14-rdkit` PGDG 202303.3	`postgresql-13-rdkit` PGDG 202303.3
`u22`	`aarch64`		`postgresql-16-rdkit` PGDG 202303.3	`postgresql-15-rdkit` PGDG 202303.3	`postgresql-14-rdkit` PGDG 202303.3	`postgresql-13-rdkit` PGDG 202303.3
`u24`	`x86_64`	`postgresql-17-rdkit` PGDG 202503.1	`postgresql-16-rdkit` PGDG 202503.1	`postgresql-15-rdkit` PGDG 202503.1	`postgresql-14-rdkit` PGDG 202503.1	`postgresql-13-rdkit` PGDG 202503.1
`u24`	`aarch64`	`postgresql-17-rdkit` PGDG 202503.1	`postgresql-16-rdkit` PGDG 202503.1	`postgresql-15-rdkit` PGDG 202503.1	`postgresql-14-rdkit` PGDG 202503.1	`postgresql-13-rdkit` PGDG 202503.1

Installation

Install rdkit via the pig CLI tool:

pig ext install rdkit

Install rdkit via Pigsty playbook:

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

Install rdkit DEB from APT repo directly:

apt install postgresql-16-rdkit;
apt install postgresql-15-rdkit;
apt install postgresql-14-rdkit;
apt install postgresql-13-rdkit;

Create rdkit extension on PostgreSQL cluster:

CREATE EXTENSION rdkit;

18 - omni

Advanced adapter for Postgres extensions

Overview

PIGSTY 3rd Party Extension: omnigres : Advanced adapter for Postgres extensions

Information

Extension ID: 2951
Extension Name: omni
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://github.com/omnigres/omnigres
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.2.9
Postgres Support: 17,16,15,14,13
Need Load: Explicit Loading Required
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Untrusted, Require Superuser to Create
Schemas: omni
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.2.9
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.2.9
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Extension omni has to be loaded via shared_preload_libraries

shared_preload_libraries = 'omni'; # add to pg cluster config

Create omni extension on PostgreSQL cluster:

CREATE EXTENSION omni;

19 - omni_auth

Basic session management

Overview

PIGSTY 3rd Party Extension: omnigres : Basic session management

Information

Extension ID: 2952
Extension Name: omni_auth
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_auth/basics/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.3
Postgres Support: 17,16,15,14,13
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: omni_auth
Requires: omni_types, omni_id, pgcrypto, btree_gist, omni_polyfill

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.3
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.3
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_auth via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_auth; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_auth extension on PostgreSQL cluster:

CREATE EXTENSION omni_auth CASCADE;

20 - omni_aws

Amazon Web Services APIs (S3)

Overview

PIGSTY 3rd Party Extension: omnigres : Amazon Web Services APIs (S3)

Information

Extension ID: 2953
Extension Name: omni_aws
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_aws/s3/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.2
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: omni_aws
Requires: omni_httpc, pgcrypto, omni_xml, omni_web

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_aws via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_aws; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_aws extension on PostgreSQL cluster:

CREATE EXTENSION omni_aws CASCADE;

21 - omni_cloudevents

CloudEvents support

Overview

PIGSTY 3rd Party Extension: omnigres : CloudEvents support

Information

Extension ID: 2954
Extension Name: omni_cloudevents
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_cloudevents/cloud_events/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: omni_cloudevents
Requires: omni_web

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_cloudevents via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_cloudevents; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_cloudevents extension on PostgreSQL cluster:

CREATE EXTENSION omni_cloudevents CASCADE;

22 - omni_containers

Docker container management

Overview

PIGSTY 3rd Party Extension: omnigres : Docker container management

Information

Extension ID: 2955
Extension Name: omni_containers
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_containers/intro/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.2.0
Postgres Support: 17,16,15,14,13
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: omni_containers
Requires: omni_httpc, omni_web

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.2.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.2.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_containers via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_containers; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_containers extension on PostgreSQL cluster:

CREATE EXTENSION omni_containers CASCADE;

23 - omni_credentials

Application credential management

Overview

PIGSTY 3rd Party Extension: omnigres : Application credential management

Information

Extension ID: 2956
Extension Name: omni_credentials
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_credentials/credentials/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.2.0
Postgres Support: 17,16,15,14,13
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: omni_credentials
Requires: pgcrypto, omni_os

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.2.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.2.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_credentials via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_credentials; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_credentials extension on PostgreSQL cluster:

CREATE EXTENSION omni_credentials CASCADE;

24 - omni_email

E-mail framework

Overview

PIGSTY 3rd Party Extension: omnigres : E-mail framework

Information

Extension ID: 2958
Extension Name: omni_email
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_email/reference/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0
Postgres Support: 17,16,15,14,13
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: omni_email
Requires: omni_id, omni_cloudevents, omni_polyfill

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_email via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_email; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_email extension on PostgreSQL cluster:

CREATE EXTENSION omni_email CASCADE;

25 - omni_http

Basic HTTP types

Overview

PIGSTY 3rd Party Extension: omnigres : Basic HTTP types

Information

Extension ID: 2959
Extension Name: omni_http
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_httpc/reference/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
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: omni_http
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_http via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_http; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_http extension on PostgreSQL cluster:

CREATE EXTENSION omni_http;

26 - omni_httpc

HTTP client

Overview

PIGSTY 3rd Party Extension: omnigres : HTTP client

Information

Extension ID: 2960
Extension Name: omni_httpc
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_httpc/reference/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.5
Postgres Support: 17,16,15,14,13
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: omni_httpc
Requires: omni_http, omni_types

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.5
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.5
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_httpc via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_httpc; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_httpc extension on PostgreSQL cluster:

CREATE EXTENSION omni_httpc CASCADE;

27 - omni_httpd

HTTP server

Overview

PIGSTY 3rd Party Extension: omnigres : HTTP server

Information

Extension ID: 2961
Extension Name: omni_httpd
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_httpd/intro/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.4.6
Postgres Support: 17,16,15,14,13
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: omni_httpd
Requires: omni_types, omni_http

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.4.6
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.4.6
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_httpd via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_httpd; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_httpd extension on PostgreSQL cluster:

CREATE EXTENSION omni_httpd CASCADE;

28 - omni_id

Identity types

Overview

PIGSTY 3rd Party Extension: omnigres : Identity types

Information

Extension ID: 2962
Extension Name: omni_id
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_id/identity_type/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.4.2
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.4.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.4.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_id via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_id; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_id extension on PostgreSQL cluster:

CREATE EXTENSION omni_id;

29 - omni_json

JSON toolkit

Overview

PIGSTY 3rd Party Extension: omnigres : JSON toolkit

Information

Extension ID: 2963
Extension Name: omni_json
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_json/table_mapping/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.1
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can be installed into other schemas
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: omni_json
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_json via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_json; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_json extension on PostgreSQL cluster:

CREATE EXTENSION omni_json;

30 - omni_kube

Kubernetes (k8s) integration

Overview

PIGSTY 3rd Party Extension: omnigres : Kubernetes (k8s) integration

Information

Extension ID: 2964
Extension Name: omni_kube
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_kube/api/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.1
Postgres Support: 17,16,15,14,13
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: omni_kube
Requires: omni_httpc, omni_web, omni_var, pgcrypto

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_kube via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_kube; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_kube extension on PostgreSQL cluster:

CREATE EXTENSION omni_kube CASCADE;

31 - omni_ledger

Financial ledger

Overview

PIGSTY 3rd Party Extension: omnigres : Financial ledger

Information

Extension ID: 2965
Extension Name: omni_ledger
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_ledger/basics/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.2
Postgres Support: 17,16,15,14,13
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: omni_ledger
Requires: omni_id, omni_polyfill

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_ledger via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_ledger; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_ledger extension on PostgreSQL cluster:

CREATE EXTENSION omni_ledger CASCADE;

32 - omni_manifest

Package installation manifests

Overview

PIGSTY 3rd Party Extension: omnigres : Package installation manifests

Information

Extension ID: 2966
Extension Name: omni_manifest
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_manifest/usage/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.2
Postgres Support: 17,16,15,14,13
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: omni_manifest
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_manifest via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_manifest; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_manifest extension on PostgreSQL cluster:

CREATE EXTENSION omni_manifest;

33 - omni_mimetypes

MIME types

Overview

PIGSTY 3rd Party Extension: omnigres : MIME types

Information

Extension ID: 2967
Extension Name: omni_mimetypes
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_mimetypes/reference/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
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: omni_mimetypes
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_mimetypes via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_mimetypes; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_mimetypes extension on PostgreSQL cluster:

CREATE EXTENSION omni_mimetypes;

34 - omni_os

Operating system integration

Overview

PIGSTY 3rd Party Extension: omnigres : Operating system integration

Information

Extension ID: 2968
Extension Name: omni_os
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_os/intro/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.1
Postgres Support: 17,16,15,14,13
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: omni_os
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_os via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_os; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_os extension on PostgreSQL cluster:

CREATE EXTENSION omni_os;

35 - omni_polyfill

Postgres API polyfills

Overview

PIGSTY 3rd Party Extension: omnigres : Postgres API polyfills

Information

Extension ID: 2969
Extension Name: omni_polyfill
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_polyfill/polyfills/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.2.2
Postgres Support: 17,16,15,14,13
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: omni_polyfill
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.2.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.2.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_polyfill via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_polyfill; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_polyfill extension on PostgreSQL cluster:

CREATE EXTENSION omni_polyfill;

36 - omni_python

First-class Python support

Overview

PIGSTY 3rd Party Extension: omnigres : First-class Python support

Information

Extension ID: 2970
Extension Name: omni_python
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_python/intro/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.1
Postgres Support: 17,16,15,14,13
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: omni_python
Requires: plpython3u

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_python via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_python; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_python extension on PostgreSQL cluster:

CREATE EXTENSION omni_python CASCADE;

37 - omni_regex

PCRE-compatible regular expressions

Overview

PIGSTY 3rd Party Extension: omnigres : PCRE-compatible regular expressions

Information

Extension ID: 2971
Extension Name: omni_regex
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_regex/regex/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_regex via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_regex; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_regex extension on PostgreSQL cluster:

CREATE EXTENSION omni_regex;

38 - omni_rest

REST API toolkit (with PostgREST support)

Overview

PIGSTY 3rd Party Extension: omnigres : REST API toolkit (with PostgREST support)

Information

Extension ID: 2972
Extension Name: omni_rest
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_rest/protocols/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.1
Postgres Support: 17,16,15,14,13
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: omni_rest
Requires: omni_httpd, omni_sql, omni_web, omni_var, pgcrypto

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_rest via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_rest; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_rest extension on PostgreSQL cluster:

CREATE EXTENSION omni_rest CASCADE;

39 - omni_schema

Advanced schema management tooling

Overview

PIGSTY 3rd Party Extension: omnigres : Advanced schema management tooling

Information

Extension ID: 2973
Extension Name: omni_schema
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_schema/reference/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.3.0
Postgres Support: 17,16,15,14,13
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: omni_schema
Requires: omni_sql, omni_vfs, dblink

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.3.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.3.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_schema via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_schema; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_schema extension on PostgreSQL cluster:

CREATE EXTENSION omni_schema CASCADE;

40 - omni_seq

Distributed integer sequences

Overview

PIGSTY 3rd Party Extension: omnigres : Distributed integer sequences

Information

Extension ID: 2974
Extension Name: omni_seq
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_seq/id/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.1
Postgres Support: 17,16,15,14,13
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: omni_seq
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_seq via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_seq; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_seq extension on PostgreSQL cluster:

CREATE EXTENSION omni_seq;

41 - omni_service

Service management

Overview

PIGSTY 3rd Party Extension: omnigres : Service management

Information

Extension ID: 2975
Extension Name: omni_service
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_service/management/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
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: omni_service
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_service via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_service; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_service extension on PostgreSQL cluster:

CREATE EXTENSION omni_service;

42 - omni_session

Session management

Overview

PIGSTY 3rd Party Extension: omnigres : Session management

Information

Extension ID: 2976
Extension Name: omni_session
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_session/session_management/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.2.0
Postgres Support: 17,16,15,14,13
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: omni_session
Requires: omni_var, omni_id, omni_web, omni_httpd, omni_polyfill

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.2.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.2.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_session via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_session; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_session extension on PostgreSQL cluster:

CREATE EXTENSION omni_session CASCADE;

43 - omni_sql

Programmatic SQL manipulation

Overview

PIGSTY 3rd Party Extension: omnigres : Programmatic SQL manipulation

Information

Extension ID: 2977
Extension Name: omni_sql
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://github.com/omnigres/omnigres
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.5.1
Postgres Support: 17,16,15,14,13
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: omni_sql
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.5.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.5.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_sql via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_sql; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_sql extension on PostgreSQL cluster:

CREATE EXTENSION omni_sql;

44 - omni_sqlite

Embedded SQLite

Overview

PIGSTY 3rd Party Extension: omnigres : Embedded SQLite

Information

Extension ID: 2979
Extension Name: omni_sqlite
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_sqlite/sqlite/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.2
Postgres Support: 17,16,15,14,13
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: omni_sqlite
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_sqlite via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_sqlite; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_sqlite extension on PostgreSQL cluster:

CREATE EXTENSION omni_sqlite;

45 - omni_test

Testing framework

Overview

PIGSTY 3rd Party Extension: omnigres : Testing framework

Information

Extension ID: 2980
Extension Name: omni_test
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_test/guide/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.4.0
Postgres Support: 17,16,15,14,13
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: omni_test
Requires: dblink

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.4.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.4.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_test via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_test; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_test extension on PostgreSQL cluster:

CREATE EXTENSION omni_test CASCADE;

46 - omni_txn

Transaction management

Overview

PIGSTY 3rd Party Extension: omnigres : Transaction management

Information

Extension ID: 2981
Extension Name: omni_txn
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_txn/linearize/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.5.0
Postgres Support: 17,16,15,14,13
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: omni_txn
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.5.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.5.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_txn via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_txn; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_txn extension on PostgreSQL cluster:

CREATE EXTENSION omni_txn;

47 - omni_types

Advanced types

Overview

PIGSTY 3rd Party Extension: omnigres : Advanced types

Information

Extension ID: 2982
Extension Name: omni_types
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_types/function_signature_types/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.3.4
Postgres Support: 17,16,15,14,13
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: omni_types
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.3.4
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.3.4
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_types via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_types; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_types extension on PostgreSQL cluster:

CREATE EXTENSION omni_types;

48 - omni_var

Scoped variables

Overview

PIGSTY 3rd Party Extension: omnigres : Scoped variables

Information

Extension ID: 2983
Extension Name: omni_var
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_var/variables/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.3.0
Postgres Support: 17,16,15,14,13
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: omni_var
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.3.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.3.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_var via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_var; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_var extension on PostgreSQL cluster:

CREATE EXTENSION omni_var;

49 - omni_vfs

Virtual File System

Overview

PIGSTY 3rd Party Extension: omnigres : Virtual File System

Information

Extension ID: 2984
Extension Name: omni_vfs
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_vfs/reference/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.2.1
Postgres Support: 17,16,15,14,13
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: omni_vfs
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.2.1
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.2.1
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_vfs via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_vfs; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_vfs extension on PostgreSQL cluster:

CREATE EXTENSION omni_vfs;

50 - omni_vfs_types_v1

Virtual File System types (v1)

Overview

PIGSTY 3rd Party Extension: omnigres : Virtual File System types (v1)

Information

Extension ID: 2985
Extension Name: omni_vfs_types_v1
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://github.com/omnigres/omnigres
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
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: omni_vfs_types_v1
Requires: omni_vfs_types_v1, dblink

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_vfs_types_v1 via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_vfs_types_v1; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_vfs_types_v1 extension on PostgreSQL cluster:

CREATE EXTENSION omni_vfs_types_v1 CASCADE;

51 - omni_web

Common web stack primitives

Overview

PIGSTY 3rd Party Extension: omnigres : Common web stack primitives

Information

Extension ID: 2986
Extension Name: omni_web
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_web/intro/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.3.0
Postgres Support: 17,16,15,14,13
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: omni_web
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.3.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.3.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_web via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_web; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_web extension on PostgreSQL cluster:

CREATE EXTENSION omni_web;

52 - omni_worker

Generalized worker pool

Overview

PIGSTY 3rd Party Extension: omnigres : Generalized worker pool

Information

Extension ID: 2987
Extension Name: omni_worker
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_worker/intro/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
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: omni_worker
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_worker via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_worker; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_worker extension on PostgreSQL cluster:

CREATE EXTENSION omni_worker;

53 - omni_xml

XML toolkit

Overview

PIGSTY 3rd Party Extension: omnigres : XML toolkit

Information

Extension ID: 2988
Extension Name: omni_xml
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_xml/overview/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.2
Postgres Support: 17,16,15,14,13
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: omni_xml
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.2
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.2
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_xml via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_xml; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_xml extension on PostgreSQL cluster:

CREATE EXTENSION omni_xml;

54 - omni_yaml

YAML toolkit

Overview

PIGSTY 3rd Party Extension: omnigres : YAML toolkit

Information

Extension ID: 2989
Extension Name: omni_yaml
Package Name: omnigres
Category: FEAT
License: Apache-2.0
Website: https://docs.omnigres.org/omni_yaml/yaml/
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.1.0
Postgres Support: 17,16,15,14,13
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: omni_yaml
Requires: N/A

RPM / DEB

RPM Repo: PIGSTY
RPM Name: omnigres_$v
RPM Ver : 0.1.0
RPM Deps: N/A
DEB Repo: PIGSTY
DEB Name: postgresql-$v-omnigres
DEB Ver : 0.1.0
DEB Deps: N/A

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el8`	`aarch64`	`omnigres_17` PIGSTY 20250120	`omnigres_16` PIGSTY 20250120	`omnigres_15` PIGSTY 20250120	`omnigres_14` PIGSTY 20250120	`omnigres_13` PIGSTY 20250120
`el9`	`x86_64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`el9`	`aarch64`	`omnigres_17` PIGSTY 20250507	`omnigres_16` PIGSTY 20250507	`omnigres_15` PIGSTY 20250507	`omnigres_14` PIGSTY 20250507	`omnigres_13` PIGSTY 20250507
`d12`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`d12`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u22`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250120	`postgresql-16-omnigres` PIGSTY 20250120	`postgresql-15-omnigres` PIGSTY 20250120	`postgresql-14-omnigres` PIGSTY 20250120	`postgresql-13-omnigres` PIGSTY 20250120
`u24`	`x86_64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507
`u24`	`aarch64`	`postgresql-17-omnigres` PIGSTY 20250507	`postgresql-16-omnigres` PIGSTY 20250507	`postgresql-15-omnigres` PIGSTY 20250507	`postgresql-14-omnigres` PIGSTY 20250507	`postgresql-13-omnigres` PIGSTY 20250507

Installation

Install omni_yaml via the pig CLI tool:


pig ext install omnigres; 	# Extension Name
pig ext install omni_yaml; 	# normalized package name

Install omnigres via Pigsty playbook:

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

Install omnigres RPM from YUM repo directly:

dnf install omnigres_17;
dnf install omnigres_16;
dnf install omnigres_15;
dnf install omnigres_14;
dnf install omnigres_13;

Install omnigres DEB from APT repo directly:

apt install postgresql-17-omnigres;
apt install postgresql-16-omnigres;
apt install postgresql-15-omnigres;
apt install postgresql-14-omnigres;
apt install postgresql-13-omnigres;

Create omni_yaml extension on PostgreSQL cluster:

CREATE EXTENSION omni_yaml;

55 - bloom

bloom access method - signature file based index

Overview

CONTRIB Built-in Extension: bloom : bloom access method - signature file based index

Information

Extension ID: 2990
Extension Name: bloom
Package Name: None
Category: FEAT
License: PostgreSQL
Website: https://www.postgresql.org/docs/current/bloom.html
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 1.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

PostgreSQL Built-in Contrib Extension

Availability

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`
`el8`	`aarch64`
`el9`	`x86_64`
`el9`	`aarch64`
`d12`	`x86_64`
`d12`	`aarch64`
`u22`	`x86_64`
`u22`	`aarch64`
`u24`	`x86_64`
`u24`	`aarch64`

Installation

Extension bloom is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Install bloom RPM from YUM repo directly:

dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;

Install bloom DEB from APT repo directly:

apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;

Create bloom extension on PostgreSQL cluster:

CREATE EXTENSION bloom;