PostgreSQL Extension Cloud
PGEXT.CLOUD provides three things to help you harness the synergistic superpower of the PostgreSQL extensions ecosystem:
- Catalog : Find the extension you need, with unparalleled 431 extensions included
- Repository : Get pre-built RPM/DEB packages on 14 mainstream Linux Distributions
- PIG Package Manager : The Missing Package Manager for PostgreSQL & Extension Ecosystem
The complete list of 430+ available PostgreSQL extensions
The APT / DNF repo that deliver PostgreSQL extensions in native Linux format
The missing package manager for PostgreSQL & Extensions Ecosystem
curl -fsSL https://repo.pigsty.io/pig | bash # install pig cli
pig repo set # setup upstream repository on your linux
pig install pg18 # install PostgreSQL 18 kernel pkg from PGDG
pig install pg_duckdb -v 18 # e.g. install pg_duckdb extension for PG 18Just use PostgreSQL for everything! Also check our blog post: PostgreSQL is eating the Database World
Highlights
- 431 Extensions : the largest catalog in the postgres ecosystem
- Linux Native : RPM/DEB packages, properly built, freely compose
- Handy CLI : pig on apt/dnf, zero‑config installs; out-of-the-box
- Compatibility : PGDG‑Compliant, drop‑in with official PG kernel
- Fast & Reliable : Distribute via Cloudflare CDN in worldwide
- Commitment : Driven by PG experts, with love and commitment
- Free & OSS : Reproducible building, Public infra, free for all
Catalog
TIME
|
GIS
|
RAG
|
FTS
|
OLAP
|
FEAT
|
LANG
|
TYPE
|
|---|---|---|---|---|---|---|---|
UTIL
|
FUNC
|
ADMIN
|
STAT
|
SEC
|
FDW
|
SIM
|
ETL
|
TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…
ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…
DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …
OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…
Develop, Test, Package, and Deliver Stored Procedures written in various PL/Languages: Java, Js, Lua, R, Sh, PRQL, …
Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,…
Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…
Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Error, Extension White List, …
Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!
Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…
MIT
|
ISC
|
PostgreSQL
|
BSD 0-Clause
|
BSD 2-Clause
|
BSD 3-Clause
|
|---|---|---|---|---|---|
Artistic
|
Apache-2.0
|
MPL-2.0
|
|||
GPL-2.0
|
GPL-3.0
|
LGPL-2.1
|
LGPL-3.0
|
AGPL-3.0
|
Timescale
|
C
|
C++
|
Rust
|
Java
|
Python
|
SQL
|
Data
|
|---|
Platform
Pigsty provides complete extension support on these linux distributions major versions::
| OS | Vendor | Major | Minor | Fullname | PG Major Version | Comment |
|---|---|---|---|---|---|---|
el8.x86_64
|
EL | 8 | 8.10 | RockyLinux 8 x86 | 18
17
16
15
14
13
|
Near EOL
|
el8.aarch64
|
EL | 8 | 8.10 | RockyLinux 8 ARM | 18
17
16
15
14
13
|
Near EOL
|
el9.x86_64
|
EL | 9 | 9.6 | RockyLinux 9 x86 | 18
17
16
15
14
13
|
OK
|
el9.aarch64
|
EL | 9 | 9.6 | RockyLinux 9 ARM | 18
17
16
15
14
13
|
OK
|
el10.x86_64
|
EL | 10 | 10.0 | RockyLinux 10 x86 | 18
17
16
15
14
13
|
OK
|
el10.aarch64
|
EL | 10 | 10.0 | RockyLinux 10 ARM | 18
17
16
15
14
13
|
OK
|
d12.x86_64
|
Debian | 12 | 12.12 | Debian 12 x86 | 18
17
16
15
14
13
|
OK
|
d12.aarch64
|
Debian | 12 | 12.12 | Debian 12 ARM | 18
17
16
15
14
13
|
OK
|
d13.x86_64
|
Debian | 13 | 13.1 | Debian 13 x86 | 18
17
16
15
14
13
|
OK
|
d13.aarch64
|
Debian | 13 | 13.1 | Debian 13 ARM | 18
17
16
15
14
13
|
OK
|
u22.x86_64
|
Ubuntu | 22 | 22.04.5 | Ubuntu 22.04 x86 | 18
17
16
15
14
13
|
OK
|
u22.aarch64
|
Ubuntu | 22 | 22.04.5 | Ubuntu 22.04 ARM | 18
17
16
15
14
13
|
OK
|
u24.x86_64
|
Ubuntu | 24 | 24.04.3 | Ubuntu 24.04 x86 | 18
17
16
15
14
13
|
OK
|
u24.aarch64
|
Ubuntu | 24 | 24.04.3 | Ubuntu 24.04 ARM | 18
17
16
15
14
13
|
OK
|
Users
The PGSTY.CLOUD is used by some PostgreSQL Distribution Maker and Vendors:
About
The PGEXT.CLOUD is maintained by PGSTY / VONNG ([email protected]), and open-sourced under the Apache License 2.0.
| GitHub Repo | Description |
|---|---|
| github.com/pgsty | The PGSTY Organization |
| github.com/pgsty/pgext | This website and extension Data |
| github.com/pgsty/pigsty | PostgreSQL Database Distribution |
| github.com/pgsty/pig | PostgreSQL Package Manager |
| github.com/pgsty/ext | This documentation site, Extension Catalog |
| github.com/pgsty/rpm | RPM Building Specs |
| github.com/pgsty/deb | DEB Building Specs |
| github.com/pgsty/infra-pkg | Infra Package Building Specs |
Last updated on