Tasks

Look up common tasks and how to perform them using a short sequence of steps

Nginx: Expose Web Service with the Infra Portal

How to expose, proxy, and forward upstream & serve local path using Nginx?

Certbot: Free HTTPS Certs

How to apply free Let’s Encrypt HTTPS certificates with certbot?

Docker: Setup & Proxy

How to configure container support in Pigsty? and how to configure mirror & proxy for DockerHub?

Use PostgreSQL as Ansible Config Inventory CMDB

Use PostgreSQL instead of static YAML config file as Ansible config inventory

Use PG as Grafana Backend

Use PostgreSQL instead of default SQLite, as the backend storage for Grafana

Use PG as Prometheus Backend

Persist prometheus metrics with PostgreSQL + TimescaleDB through Promscale

Bind a L2 VIP to Node Cluster with Keepalived

How to bind an optional L2 VIP to a node cluster with keepalived?

Bind a L2 VIP to PostgreSQL Primary with VIP-Manager

How to bind an optional L2 VIP to a PostgreSQL cluster with VIP-Manager?

HugePage: Enable for PostgreSQL

How to allocate precise huge pages for PostgreSQL clusters?

Citus: HA Cluster

How to deploy a native HA citus cluster with Pigsty & Patroni?

HA Drill: 2/3 Failure

How to recover from emergency scenario with 2-node broken in a 3-node setup?

Restic: FS Backup/Recovery

How to use Restic for regular file system backup and recovery

JuiceFS: S3FS & PGFS

How to build a distributed cloud-native filesystem JuiceFS using PostgreSQL and MinIO provided by Pigsty.


Last modified 2025-02-27: update v3.3.0 release note (fa75a7d)