Skip to content

Extensions

Harness the synergistic power of PostgreSQL extensions

Pigsty provides 575 packaged extensions, covering 16 major categories including time-series, geospatial, vector, full-text search, analytics, and feature enhancements, ready to use out-of-the-box.

Using extensions in Pigsty involves four core steps: Download, Install, Config/Load, and Create.

pg-meta:
  hosts: { 10.10.10.10: { pg_seq: 1, pg_role: primary } }
  vars:
    pg_cluster: pg-meta
    pg_databases:
      - name: meta
        extensions: [ postgis, timescaledb, vector ]   # Create: Create extensions in database
    pg_libs: 'timescaledb, pg_stat_statements, auto_explain' # Config: Preload extension libraries
    pg_extensions: [ postgis, timescaledb, pgvector ]  # Install: Install extension packages
Pigsty PostgreSQL extension ecosystem
Quick Start

Four-step process overview for using extensions

Introduction

Core concepts of PostgreSQL extensions and the Pigsty extension ecosystem

Packages

Extension package aliases and category naming conventions

Download

Download extension packages from software repositories to local

Install

Install extension packages on cluster nodes

Config

Preload extension libraries and configure extension parameters

Create

Create and enable extensions in databases

Update

Upgrade PostgreSQL extension versions

Remove

Uninstall PostgreSQL extensions

Repository

Pigsty extension software repository configuration