The PIG CLI
Postgres Install Genius, the missing extension package manager for PostgreSQL ecosystem
PostgreSQL Extension
Pigsty has 400+ available PostgreSQL extensions available!
“PostgreSQL is eating the database world” (through extensions!) Let’s harness the synergistic power of 400+ PostgreSQL extension together with the pig package manager and the pigsty repo & distribution.
Extension List
The complete 405 PostgreSQL Extension List available in Pigsty
Extension Repo
How to use PostgreSQL extension YUM/APT repo on EL/Debian/Ubuntu and compatible os?
Extension Usage
How to install, load, create, update, remove PostgreSQL extensions in Pigsty?
Build & Packaging
Prepare PostgreSQL rpm/deb pacakge building environment, and some packaging hints
Roadmap
Extension Rodapmap, on our radar, backlogs, defects, changes, and retired list.
Category: TIME
TIME: TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
Category: GIS
GIS: GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
Category: RAG
RAG: Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…
Category: FTS
FTS: ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…
Category: OLAP
OLAP: DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …
Category: FEAT
FEAT: OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…
Category: LANG
LANG: Develop, Test, Package, and Deliver Stored Procedures written in various PL/Lanaguages: Java, Js, Lua, R, Sh, PRQL, …
Category: TYPE
TYPE: Dedicate New Data Types Like: prefix, sember, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
Category: UTIL
UTIL: Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,…
Category: FUNC
FUNC: Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…
Category: ADMIN
ADMIN: Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
Category: STAT
STAT: Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
Category: SEC
SEC: Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Erros, Extension White List, …
Category: FDW
FDW: Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
Category: SIM
SIM: Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!
Category: ETL
ETL: Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.