OPEN SOURCE DATA INFRASTRUCTURE
Deploy PostgreSQL, store objects, manage packages, and test locally. Find the purpose, documentation, and source code for each project.
FLAGSHIP PROJECTS
Tools for deployment, storage, packages, metrics, and test environments. Use them independently or combine them around your needs.
PG DISTRIBUTION
A complete PostgreSQL distribution with automated deployment, high availability, monitoring, and extensions.
Use it for: Deploying and operating PostgreSQL on your own servers or cloud virtual machines.
curl -fsSL https://repo.pigsty.io/get | bash
OBJECT STORAGE
An S3-compatible object storage server maintained as a MinIO fork, with a console and release packages.
Use it for: Providing an S3-compatible storage endpoint on infrastructure you manage.
docker pull pgsty/silo
PACKAGE MANAGER
A command-line package manager for installing PostgreSQL and its extensions across supported Linux distributions.
Use it for: Preparing PostgreSQL environments and managing database extension packages.
curl -fsSL https://repo.pigsty.io/pig | bash
VIRTUAL MACHINES
A local lightweight VM tool for macOS and Linux, building reproducible multi-node lab environments.
Use it for: Spin up local lightweight VMs to test multi-node database clusters.
brew install pgsty/infra/barn
REPO MANAGER
A repository manager for RPM and DEB packages, featuring repository indexing and incremental publishing.
Use it for: Publishing and maintaining Linux package repositories.
sow create ./packages
METRICS EXPORTER
A Prometheus metrics exporter for PostgreSQL and PgBouncer, with declarative collector configuration.
Use it for: Collecting database metrics for Prometheus monitoring and Grafana dashboards.
docker pull pgsty/pg_exporter
WORKING TOGETHER
Test changes locally, prepare packages, deploy the cluster, then configure backup and monitoring. Each stage has its own tools and documentation.
Rapidly spin up lightweight VMs to test topologies and changes safely.
Install PostgreSQL and extensions with PIG; publish private APT/YUM repositories with SOW.
Deploy PostgreSQL, Patroni high availability, and PgBouncer pooling from configuration.
Provide S3-compatible backup storage for pgBackRest and PostgreSQL point-in-time recovery.
Collect database and pooler metrics for Prometheus and inspect them in Grafana.
EXTENSIONS & DEVELOPER TOOLS
We also develop, maintain, or contribute to projects for character sets, object storage, WebAssembly, and localization. Each repository documents its scope and maturity.
S3-compatible object storage inside PostgreSQL, keeping objects and metadata in the database. An early alpha project for evaluation.
Run WebAssembly components inside PostgreSQL and expose them as typed SQL functions. Our fork follows the upstream pgwasm project.
Chinese translations of PostgreSQL server messages and command-line tools, with tooling to maintain and review localization work.
An extension catalog and metadata pipeline for finding PostgreSQL extensions, supported versions, and available packages.
Keyboard configurations that turn Caps Lock into a modifier for navigation, window control, and developer shortcuts on macOS.
COMMUNITY FOUNDATIONS
Documentation, connected references, and package repositories help everyone install, understand, and use PostgreSQL.
Chinese translations of PostgreSQL manuals across versions, with full-text search and version comparisons.
English PostgreSQL documentation hub, version diffs, all GUC configuration parameters, and catalog references.
Connected knowledge graph visualizing the relationships between SQL commands, parameters, functions, and catalogs.
RPM and DEB packages for PostgreSQL, extensions, and supporting software, with global and mainland China endpoints.
A local-first Hugo Extended documentation theme without an npm build step, used across PGSTY sites.
Explore all public repositories, release tags, and discussions. Issues, pull requests, and contributions welcome.
PGSTY develops and maintains software for PostgreSQL deployment, object storage, package management, monitoring, repository publishing, and local testing. We also contribute to extension and developer tool projects. The links above lead to their source code and documentation.
Start with the relevant project documentation for installation requirements, supported platforms, and releases. For a production deployment, our professional services can help with assessment, implementation, and operational handover.
Licences vary by project: Pigsty, PIG, pg_exporter, SOW, Barn, and OINK use Apache-2.0; Silo uses AGPL-3.0; pgwasm uses BSD-3-Clause. Contributions, translations, and dependencies retain their applicable terms. Refer to each repository’s licence file for details.
Public documentation, releases, and community discussions are available through the project links. Commercial support is a separate engagement with an agreed scope; availability of open-source software does not create a support or service-level commitment.
WORK WITH PGSTY
Tell us about your environment, objectives, and timeline. We will help you define the next step.