Download

Before installing extensions, ensure that extension packages are downloaded to the local repository or available from upstream.

Default Behavior

Pigsty downloads the base PostgreSQL 18 kernel packages to the local software repository by default. The default extra download set is repo_extra_packages_default: [ pgsql-main ], which includes the PostgreSQL kernel, client, procedural languages, and basic extension packages such as pg_repack, wal2json, and pgvector.

If you need other extensions from the 531-extension catalog, explicitly add them to repo_extra_packages. Pigsty does not download every extension to the local repository by default.

Benefits of using a local repository:

• Accelerated installation, avoiding repeated downloads
• Reduced network traffic consumption
• Improved delivery reliability
• Ensured version consistency

Download New Extensions

To download additional extensions, add them to repo_extra_packages and rebuild the repository:

all:
  vars:
    repo_extra_packages: [ pgvector, postgis, timescaledb, pg_duckdb ]

# Re-download packages to local repository
./infra.yml -t repo_build

# Refresh package source cache on all nodes
./node.yml -t node_repo

Using Upstream Repositories

You can also install directly from internet upstream repositories without pre-downloading:

# Add upstream software sources on nodes
./node.yml -t node_repo -e node_repo_modules=node,pgsql

This approach is suitable for:

• Quick testing of latest versions
• Installing rare extensions
• Environments with good network conditions

But may face:

• Network instability affecting installation
• Version inconsistency risks

Extension Sources

Extension packages come from two main sources:

The Pigsty repository only includes extensions not present in the PGDG repository. Once an extension enters the PGDG repository, the Pigsty repository will remove it or keep it consistent.

Repository URLs:

• PGDG YUM: https://download.postgresql.org/pub/repos/yum/
• PGDG APT: https://apt.postgresql.org/pub/repos/apt/
• Pigsty YUM: https://repo.pigsty.io/yum/
• Pigsty APT: https://repo.pigsty.io/apt/

For detailed repository configuration, see Extension Repository.