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,…
FEAT category has 52 available extensions:
1 - omni
Advanced adapter for Postgres extensions
Overview
PIGSTY 3rd Party Extension: omnigres : Advanced adapter for Postgres extensions
- Latest Version: 0.2.4
- 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.4
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-omnigres
- DEB Ver :
0.2.4
- DEB Deps: N/A
Packages
Installation
Install omni via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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 added to shared_preload_libraries
shared_preload_libraries = 'omni'; # add to pg cluster config
Enable omni extension on PostgreSQL cluster：
2 - omni_auth
Basic session management
Overview
PIGSTY 3rd Party Extension: omnigres : Basic session management
- 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_auth
- Requires:
omni_types, omni_id, pgcrypto, btree_gist, 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
Packages
Installation
Install omni_auth via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_auth extension on PostgreSQL cluster：
CREATE EXTENSION omni_auth CASCADE;
3 - omni_aws
Amazon Web Services APIs (S3)
Overview
PIGSTY 3rd Party Extension: omnigres : Amazon Web Services APIs (S3)
- 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
Packages
Installation
Install omni_aws via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_aws extension on PostgreSQL cluster：
CREATE EXTENSION omni_aws CASCADE;
4 - omni_containers
Docker container management
Overview
PIGSTY 3rd Party Extension: omnigres : Docker container management
- 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
Packages
Installation
Install omni_containers via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_containers extension on PostgreSQL cluster：
CREATE EXTENSION omni_containers CASCADE;
5 - omni_credentials
Application credential management
Overview
PIGSTY 3rd Party Extension: omnigres : Application credential management
- 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_credentials
- Requires:
pgcrypto, omni_os
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
Packages
Installation
Install omni_credentials via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_credentials extension on PostgreSQL cluster：
CREATE EXTENSION omni_credentials CASCADE;
6 - omni_http
Basic HTTP types
Overview
PIGSTY 3rd Party Extension: omnigres : Basic HTTP types
- 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
Packages
Installation
Install omni_http via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_http extension on PostgreSQL cluster：
CREATE EXTENSION omni_http;
7 - omni_httpc
HTTP client
Overview
PIGSTY 3rd Party Extension: omnigres : HTTP client
- Latest Version: 0.1.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_httpc
- Requires:
omni_http, omni_types
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
omnigres_$v
- RPM Ver :
0.1.4
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-omnigres
- DEB Ver :
0.1.4
- DEB Deps: N/A
Packages
Installation
Install omni_httpc via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_httpc extension on PostgreSQL cluster：
CREATE EXTENSION omni_httpc CASCADE;
8 - omni_httpd
HTTP server
Overview
PIGSTY 3rd Party Extension: omnigres : HTTP server
- Latest Version: 0.2.9
- 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.2.9
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-omnigres
- DEB Ver :
0.2.9
- DEB Deps: N/A
Packages
Installation
Install omni_httpd via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_httpd extension on PostgreSQL cluster：
CREATE EXTENSION omni_httpd CASCADE;
9 - omni_id
Identity types
Overview
PIGSTY 3rd Party Extension: omnigres : Identity types
- 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 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.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-omnigres
- DEB Ver :
0.4.0
- DEB Deps: N/A
Packages
Installation
Install omni_id via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_id extension on PostgreSQL cluster：
CREATE EXTENSION omni_id;
10 - omni_json
JSON toolkit
Overview
PIGSTY 3rd Party Extension: omnigres : JSON toolkit
- 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
Packages
Installation
Install omni_json via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_json extension on PostgreSQL cluster：
CREATE EXTENSION omni_json;
11 - omni_kube
Kubernetes (k8s) integration
Overview
PIGSTY 3rd Party Extension: omnigres : Kubernetes (k8s) integration
- 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
Packages
Installation
Install omni_kube via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_kube extension on PostgreSQL cluster：
CREATE EXTENSION omni_kube CASCADE;
12 - omni_ledger
Financial ledger
Overview
PIGSTY 3rd Party Extension: omnigres : Financial ledger
- 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_ledger
- Requires:
omni_id, omni_polyfill
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
Packages
Installation
Install omni_ledger via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_ledger extension on PostgreSQL cluster：
CREATE EXTENSION omni_ledger CASCADE;
13 - omni_manifest
Package installation manifests
Overview
PIGSTY 3rd Party Extension: omnigres : Package installation manifests
- 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_manifest
- 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
Packages
Installation
Install omni_manifest via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_manifest extension on PostgreSQL cluster：
CREATE EXTENSION omni_manifest;
14 - omni_mimetypes
MIME types
Overview
PIGSTY 3rd Party Extension: omnigres : MIME types
- 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
Packages
Installation
Install omni_mimetypes via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_mimetypes extension on PostgreSQL cluster：
CREATE EXTENSION omni_mimetypes;
15 - omni_os
Operating system integration
Overview
PIGSTY 3rd Party Extension: omnigres : Operating system integration
- 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
Packages
Installation
Install omni_os via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_os extension on PostgreSQL cluster：
CREATE EXTENSION omni_os;
16 - omni_polyfill
Postgres API polyfills
Overview
PIGSTY 3rd Party Extension: omnigres : Postgres API polyfills
- 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_polyfill
- Requires: N/A
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
Packages
Installation
Install omni_polyfill via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_polyfill extension on PostgreSQL cluster：
CREATE EXTENSION omni_polyfill;
17 - omni_python
First-class Python support
Overview
PIGSTY 3rd Party Extension: omnigres : First-class Python support
- 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
Packages
Installation
Install omni_python via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_python extension on PostgreSQL cluster：
CREATE EXTENSION omni_python CASCADE;
18 - omni_regex
PCRE-compatible regular expressions
Overview
PIGSTY 3rd Party Extension: omnigres : PCRE-compatible regular expressions
- 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
Packages
Installation
Install omni_regex via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_regex extension on PostgreSQL cluster：
CREATE EXTENSION omni_regex;
19 - omni_rest
REST API toolkit (with PostgREST support)
Overview
PIGSTY 3rd Party Extension: omnigres : REST API toolkit (with PostgREST support)
- 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_rest
- Requires:
omni_httpd, omni_sql, omni_web, omni_var, pgcrypto
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
Packages
Installation
Install omni_rest via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_rest extension on PostgreSQL cluster：
CREATE EXTENSION omni_rest CASCADE;
20 - omni_schema
Advanced schema management tooling
Overview
PIGSTY 3rd Party Extension: omnigres : Advanced schema management tooling
- Latest Version: 0.2.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_schema
- Requires:
omni_sql, omni_vfs, dblink
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
omnigres_$v
- RPM Ver :
0.2.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-omnigres
- DEB Ver :
0.2.3
- DEB Deps: N/A
Packages
Installation
Install omni_schema via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_schema extension on PostgreSQL cluster：
CREATE EXTENSION omni_schema CASCADE;
21 - omni_seq
Distributed integer sequences
Overview
PIGSTY 3rd Party Extension: omnigres : Distributed integer sequences
- 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
Packages
Installation
Install omni_seq via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_seq extension on PostgreSQL cluster：
CREATE EXTENSION omni_seq;
22 - omni_service
Service management
Overview
PIGSTY 3rd Party Extension: omnigres : Service management
- 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
Packages
Installation
Install omni_service via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_service extension on PostgreSQL cluster：
CREATE EXTENSION omni_service;
23 - omni_session
Session management
Overview
PIGSTY 3rd Party Extension: omnigres : Session management
- 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_session
- Requires:
omni_var, omni_id, omni_web, omni_httpd, omni_polyfill
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
Packages
Installation
Install omni_session via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_session extension on PostgreSQL cluster：
CREATE EXTENSION omni_session CASCADE;
24 - omni_sql
Programmatic SQL manipulation
Overview
PIGSTY 3rd Party Extension: omnigres : Programmatic SQL manipulation
- 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_sql
- 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
Packages
Installation
Install omni_sql via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_sql extension on PostgreSQL cluster：
CREATE EXTENSION omni_sql;
25 - omni_test
Testing framework
Overview
PIGSTY 3rd Party Extension: omnigres : Testing framework
- 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_test
- Requires:
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
Packages
Installation
Install omni_test via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_test extension on PostgreSQL cluster：
CREATE EXTENSION omni_test CASCADE;
26 - omni_txn
Transaction management
Overview
PIGSTY 3rd Party Extension: omnigres : Transaction management
- 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
Packages
Installation
Install omni_txn via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_txn extension on PostgreSQL cluster：
CREATE EXTENSION omni_txn;
27 - omni_types
Advanced types
Overview
PIGSTY 3rd Party Extension: omnigres : Advanced types
- 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_types
- 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
Packages
Installation
Install omni_types via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_types extension on PostgreSQL cluster：
CREATE EXTENSION omni_types;
28 - omni_var
Scoped variables
Overview
PIGSTY 3rd Party Extension: omnigres : Scoped variables
- 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
Packages
Installation
Install omni_var via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_var extension on PostgreSQL cluster：
CREATE EXTENSION omni_var;
29 - omni_vfs
Virtual File System
Overview
PIGSTY 3rd Party Extension: omnigres : Virtual File System
- 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_vfs
- Requires: N/A
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
Packages
Installation
Install omni_vfs via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_vfs extension on PostgreSQL cluster：
CREATE EXTENSION omni_vfs;
30 - omni_vfs_types_v1
Virtual File System types (v1)
Overview
PIGSTY 3rd Party Extension: omnigres : Virtual File System types (v1)
- 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
Packages
Installation
Install omni_vfs_types_v1 via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_vfs_types_v1 extension on PostgreSQL cluster：
CREATE EXTENSION omni_vfs_types_v1 CASCADE;
31 - omni_web
Common web stack primitives
Overview
PIGSTY 3rd Party Extension: omnigres : Common web stack primitives
- 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_web
- 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
Packages
Installation
Install omni_web via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_web extension on PostgreSQL cluster：
CREATE EXTENSION omni_web;
32 - omni_xml
XML toolkit
Overview
PIGSTY 3rd Party Extension: omnigres : XML toolkit
- 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
Packages
Installation
Install omni_xml via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_xml extension on PostgreSQL cluster：
CREATE EXTENSION omni_xml;
33 - omni_yaml
YAML toolkit
Overview
PIGSTY 3rd Party Extension: omnigres : YAML toolkit
- 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
Packages
Installation
Install omni_yaml via the pig CLI tool:
pig ext install omnigres; # Extension Namepig 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;
Enable omni_yaml extension on PostgreSQL cluster：
CREATE EXTENSION omni_yaml;
34 - documentdb_core
Core API surface for DocumentDB on PostgreSQL
Overview
PIGSTY 3rd Party Extension: pg_documentdb_core : Core API surface for DocumentDB on PostgreSQL
- Latest Version: 0.100-0
- Postgres Support:
17,16,15
- 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: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_documentdb_core_$v*
- RPM Ver :
0.100-0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-documentdb-core
- DEB Ver :
0.100-0
- DEB Deps: N/A
Packages
Installation
Install documentdb_core via the pig CLI tool:
pig ext install pg_documentdb_core; # Extension Namepig ext install documentdb_core; # normalized package name
Install pg_documentdb_core via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_documentdb_core"]}' # -l <cls>
Install pg_documentdb_core RPM from YUM repo directly:
dnf install pg_documentdb_core_17*;
dnf install pg_documentdb_core_16*;
dnf install pg_documentdb_core_15*;
Install pg_documentdb_core DEB from APT repo directly:
apt install postgresql-17-documentdb-core;
apt install postgresql-16-documentdb-core;
apt install postgresql-15-documentdb-core;
Extension documentdb_core has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_documentdb_core'; # add to pg cluster config
Enable documentdb_core extension on PostgreSQL cluster：
CREATE EXTENSION documentdb_core;
Usage
Add to shared_preload_libraries first:
- shared_preload_libraries: documentdb_core, pg_stat_statements, auto_explain
+ shared_preload_libraries: pg_documentdb_core, pg_stat_statements, auto_explain
Example, create extension and perform DDL & CRUD
CREATE EXTENSION documentdb_core ;
Currently we only have documentdb_core extension, It can be used with the FerretDB 2.0+
35 - age
AGE graph database extension
Overview
MIXED 3rd Party Extension: age : AGE graph database extension
- 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
Packages
Installation
Install age via the pig CLI tool:
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_16*;
dnf install apache-age_15*;
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;
Enable age extension on PostgreSQL cluster：
36 - hll
type for storing hyperloglog data
Overview
PGDG 1st Party Extension: hll : type for storing hyperloglog data
- 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
Packages
Installation
Install hll via the pig CLI tool:
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;
Enable hll extension on PostgreSQL cluster：
37 - rum
RUM index access method
Overview
PGDG 1st Party Extension: rum : RUM index access method
- Latest Version: 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 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
Packages
Installation
Install rum via the pig CLI tool:
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;
Enable rum extension on PostgreSQL cluster：
38 - pg_graphql
pg_graphql: GraphQL support
Overview
PIGSTY 3rd Party Extension: pg_graphql : pg_graphql: GraphQL support
- Latest Version: 1.5.9
- 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.9
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-graphql
- DEB Ver :
1.5.9
- DEB Deps: N/A
Packages
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;
Enable pg_graphql extension on PostgreSQL cluster：
CREATE EXTENSION pg_graphql;
39 - pg_jsonschema
PostgreSQL extension providing JSON Schema validation
Overview
PIGSTY 3rd Party Extension: pg_jsonschema : PostgreSQL extension providing JSON Schema validation
- 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
Packages
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;
Enable pg_jsonschema extension on PostgreSQL cluster：
CREATE EXTENSION pg_jsonschema;
40 - jsquery
data type for jsonb inspection
Overview
PGDG 1st Party Extension: jsquery : data type for jsonb inspection
- Latest Version: 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 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.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-jsquery
- DEB Ver :
1.1
- DEB Deps: N/A
Packages
Installation
Install jsquery via the pig CLI tool:
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;
Enable jsquery extension on PostgreSQL cluster：
CREATE EXTENSION jsquery;
41 - 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.
- 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
Packages
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;
Enable pg_hint_plan extension on PostgreSQL cluster：
CREATE EXTENSION pg_hint_plan;
42 - hypopg
Hypothetical indexes for PostgreSQL
Overview
PGDG 1st Party Extension: hypopg : Hypothetical indexes for PostgreSQL
- 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
Packages
Installation
Install hypopg via the pig CLI tool:
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;
Enable hypopg extension on PostgreSQL cluster：
43 - index_advisor
Query index advisor
Overview
PIGSTY 3rd Party Extension: index_advisor : Query index advisor
- 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
Packages
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;
Enable index_advisor extension on PostgreSQL cluster：
CREATE EXTENSION index_advisor;
44 - plan_filter
filter statements by their execution plans.
Overview
PIGSTY 3rd Party Extension: pg_plan_filter : filter statements by their execution plans.
- 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
Packages
Installation
Install plan_filter via the pig CLI tool:
pig ext install pg_plan_filter; # Extension Namepig 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 added to shared_preload_libraries
shared_preload_libraries = 'plan_filter'; # add to pg cluster config
Extension %s does not need CREATE EXTENSION command
45 - imgsmlr
Image similarity with haar
Overview
PIGSTY 3rd Party Extension: imgsmlr : Image similarity with haar
- 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
Packages
Installation
Install imgsmlr via the pig CLI tool:
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;
Enable imgsmlr extension on PostgreSQL cluster：
CREATE EXTENSION imgsmlr;
46 - pg_ivm
incremental view maintenance on PostgreSQL
Overview
MIXED 3rd Party Extension: pg_ivm : incremental view maintenance on PostgreSQL
- Latest Version: 1.9
- 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.9
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-ivm
- DEB Ver :
1.9
- DEB Deps: N/A
Packages
Installation
Install pg_ivm via the pig CLI tool:
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;
Enable pg_ivm extension on PostgreSQL cluster：
47 - pg_incremental
Incremental Processing by Crunchy Data
Overview
MIXED 3rd Party Extension: pg_incremental : Incremental Processing by Crunchy Data
- Latest Version: 1.1
- 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: PGDG
- RPM Name:
pg_incremental_$v*
- RPM Ver :
1.0
- RPM Deps:
pg_cron_$v
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-incremental
- DEB Ver :
1.1
- DEB Deps:
postgresql-$v-cron
Packages
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;
Enable pg_incremental extension on PostgreSQL cluster：
CREATE EXTENSION pg_incremental CASCADE;
48 - 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.
- 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: 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.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pgmq
- DEB Ver :
1.5.0
- DEB Deps: N/A
Packages
Installation
Install pgmq via the pig CLI tool:
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;
Enable pgmq extension on PostgreSQL cluster：
49 - pgq
Generic queue for PostgreSQL
Overview
PGDG 1st Party Extension: pgq : Generic queue for PostgreSQL
- 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
Packages
Installation
Install pgq via the pig CLI tool:
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;
Enable pgq extension on PostgreSQL cluster：
50 - pg_cardano
A suite of Cardano-related tools
Overview
PIGSTY 3rd Party Extension: pg_cardano : A suite of Cardano-related tools
- Latest Version: 1.0.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_cardano_$v
- RPM Ver :
1.0.3
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-cardano
- DEB Ver :
1.0.3
- DEB Deps: N/A
Packages
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;
Enable pg_cardano extension on PostgreSQL cluster：
CREATE EXTENSION pg_cardano;
51 - rdkit
Cheminformatics functionality for PostgreSQL.
Overview
PGDG 1st Party Extension: rdkit : Cheminformatics functionality for PostgreSQL.
- Latest Version: 4.3.0
- 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 :
4.3.0
- DEB Deps: N/A
Packages
Installation
Install rdkit via the pig CLI tool:
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;
Enable rdkit extension on PostgreSQL cluster：
52 - bloom
bloom access method - signature file based index
Overview
CONTRIB Built-in Extension: bloom : bloom access method - signature file based index
- 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
Packages
| 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;
Enable bloom extension on PostgreSQL cluster：