Skip to content

Version v1.5.1 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.

Module: PIGSTY

  • Using TimescaleDB to store Prometheus data

    In Docs

    Historical DocsPIGSTY

    You can use postgres as the remote storage database used by the Prometheus backend. While this is not the recommended behavior, it is a good opportunity to understand how the Pigsty deployment system is used. Preparing the Postgres database vi …

    You can use postgres as the remote storage database used by the Prometheus backend. While this is not the recommended behavior, it is a good opportunity to understand how the Pigsty deployment system is used. Preparing the Postgres database vi …

  • PGWeb

    In Docs

    Historical DocsPIGSTY

    Pigsty v1.5.1 does not ship the former infra-pgweb.yml playbook or the pgweb_enabled / pgweb_username inventory parameters. PGWeb is provided as a Docker application at app/pgweb. Run PGWeb Docker is enabled on the meta node in the bundled v1.5.1 …

    Pigsty v1.5.1 does not ship the former infra-pgweb.yml playbook or the pgweb_enabled / pgweb_username inventory parameters. PGWeb is provided as a Docker application at app/pgweb. Run PGWeb Docker is enabled on the meta node in the bundled v1.5.1 …

  • Redis Deploy & Monitor

    In Docs

    Historical DocsPIGSTY

    Pigsty is also a universal application runtime that could be used for deploying & monitoring other databases and applications, such as Redis. It takes two steps to deploy a Redis cluster: Declare it Execute playbook Define Redis Redis Config Entries …

    Pigsty is also a universal application runtime that could be used for deploying & monitoring other databases and applications, such as Redis. It takes two steps to deploy a Redis cluster: Declare it Execute playbook Define Redis Redis Config Entries …

  • Customization of Postgres Template

    In Docs

    Historical DocsPIGSTY

    Parameters The template database template1 in a cluster can be customized using the PG template configuration item. This ensures that any database newly created in this database cluster comes with the same default configuration: schema, extensions, …

    Parameters The template database template1 in a cluster can be customized using the PG template configuration item. This ensures that any database newly created in this database cluster comes with the same default configuration: schema, extensions, …

  • Deploy

    In Docs

    Historical DocsPIGSTY

    There are 3 steps to deploy pigsty: prepare, configure, playbook Prepare Node Provisioning Meta Node Provisioning Admin User Provisioning Software Provisioning Configure Config Entry Config File Infrastructure Config Database Cluster Config Identity …

    There are 3 steps to deploy pigsty: prepare, configure, playbook Prepare Node Provisioning Meta Node Provisioning Admin User Provisioning Software Provisioning Configure Config Entry Config File Infrastructure Config Database Cluster Config Identity …

  • User Interface

    In Docs

    Historical DocsPIGSTY

    User Interface After completing the installation, the GUI provided by Pigsty can be accessed through a browser. http://g.pigsty -> http://10.10.10.10:80 (nginx) -> http://10.10.10.10:3000 (grafana) Visit http://<node_ip>:3000 to browse Pigsty home …

    User Interface After completing the installation, the GUI provided by Pigsty can be accessed through a browser. http://g.pigsty -> http://10.10.10.10:80 (nginx) -> http://10.10.10.10:3000 (grafana) Visit http://<node_ip>:3000 to browse Pigsty home …

  • Why Pigsty

    In Docs

    Historical DocsPIGSTY

    Why use Pigsty? Our philosophy is: use the good database, use the good database so that there is no hard-to-use database in the world! The database is the core component of an information system, a relational database is the absolute mainstay of the …

    Why use Pigsty? Our philosophy is: use the good database, use the good database so that there is no hard-to-use database in the world! The database is the core component of an information system, a relational database is the absolute mainstay of the …

  • Development Log

    In Docs

    Historical DocsPIGSTY

    2022-06-18 1.5.1 for PostgreSQL 14.4 Upgrade haproxy to 2.6.0 repotrack i686 issus on el7 New apps: wiki.js ferretDB 2022-05-21 Grafana Logo Customize Nginx Log Rework 2022-05-20 Prometheus Overview polish Grafana Overview polish DCS Overview polish …

    2022-06-18 1.5.1 for PostgreSQL 14.4 Upgrade haproxy to 2.6.0 repotrack i686 issus on el7 New apps: wiki.js ferretDB 2022-05-21 Grafana Logo Customize Nginx Log Rework 2022-05-20 Prometheus Overview polish Grafana Overview polish DCS Overview polish …

  • Roadmap

    In Docs

    Historical DocsPIGSTY

    History Time Description Release 2019-05-15 POC fa2ade31 (v0.0.1) 2020-04-30 First Commit dd64677 (v0.0.2) 2020-06-20 Validation on Testing Environment v0.1.0 2020-06-22 Interface enhancement v0.0.3 2020-07-10 PGSQL Monitoring v6 GA v0.2.0 2020-07-27 …

    History Time Description Release 2019-05-15 POC fa2ade31 (v0.0.1) 2020-04-30 First Commit dd64677 (v0.0.2) 2020-06-20 Validation on Testing Environment v0.1.0 2020-06-22 Interface enhancement v0.0.3 2020-07-10 PGSQL Monitoring v6 GA v0.2.0 2020-07-27 …

  • Community

    In Docs

    Historical DocsPIGSTY

    There’s an active Pigsty community. Search WeChat pigsty-cc and join the user group. Most answers cloud be found in FAQ. If there’s no answer to your questions, you can ask in the community. It’s most welcome to create Issues or Pull Requests if you …

    There’s an active Pigsty community. Search WeChat pigsty-cc and join the user group. Most answers cloud be found in FAQ. If there’s no answer to your questions, you can ask in the community. It’s most welcome to create Issues or Pull Requests if you …

  • Common Failures

    In Docs

    Historical DocsPIGSTY

    Hardware Faults ID Name Symptom Process H01 Primary node down pg_up = 0 for 1-3 minutes No immediate intervention required. Additional examples after the fact Removal from Access Domain Execute Case 8: Cluster Role Adjustment H02 Replica node down …

    Hardware Faults ID Name Symptom Process H01 Primary node down pg_up = 0 for 1-3 minutes No immediate intervention required. Additional examples after the fact Removal from Access Domain Execute Case 8: Cluster Role Adjustment H02 Replica node down …

  • HA Scenarios

    In Docs

    Historical DocsPIGSTY

    You can strengthen your confidence in the cluster’s HA capability through a HA scenario experiment. Below is a list of 24 typical HA failure scenarios, divided into three categories: Primary failure, Replica failure, and DCS failure, with eight …

    You can strengthen your confidence in the cluster’s HA capability through a HA scenario experiment. Below is a list of 24 typical HA failure scenarios, divided into three categories: Primary failure, Replica failure, and DCS failure, with eight …

  • FHS: File Hierarchy Structure

    In Docs

    Historical DocsPIGSTY

    Pigsty FHS #------------------------------------------------------------------------------ # pigsty # ^-----@app # extra demo application resources # ^-----@bin # bin scripts # ^-----@docs # document (can be docsified) # ^-----@files # ansible file …

    Pigsty FHS #------------------------------------------------------------------------------ # pigsty # ^-----@app # extra demo application resources # ^-----@bin # bin scripts # ^-----@docs # document (can be docsified) # ^-----@files # ansible file …

  • PGSQL SOP: Standard Operating Procedure

    In Docs

    Historical DocsPIGSTY

    Most cluster management operations require using the admin user on the meta node and the execution of the corresponding Ansible Playbook in the Pigsty root dir. Unless otherwise specified, the following examples demonstrate a three-node cluster …

    Most cluster management operations require using the admin user on the meta node and the execution of the corresponding Ansible Playbook in the Pigsty root dir. Unless otherwise specified, the following examples demonstrate a three-node cluster …

  • Migration Tutorial

    In Docs

    Historical DocsPIGSTY

    An auxiliary playbook, pgsql-migration.yml, provides a battery-included migration method based on logical replication. By filling in the information about the source and host clusters, the playbook will automatically create the scripts needed for the …

    An auxiliary playbook, pgsql-migration.yml, provides a battery-included migration method based on logical replication. By filling in the information about the source and host clusters, the playbook will automatically create the scripts needed for the …

  • CMDB Usage

    In Docs

    Historical DocsPIGSTY

    Instead of a static config file, you can use postgres as an inventory for Pigsty. Using CMDB as a dynamic Inventory for Ansible has several advantages: metadata is presented as data tables in a highly structured way, and database constraints ensure …

    Instead of a static config file, you can use postgres as an inventory for Pigsty. Using CMDB as a dynamic Inventory for Ansible has several advantages: metadata is presented as data tables in a highly structured way, and database constraints ensure …

  • Offline Installation

    In Docs

    Historical DocsPIGSTY

    Pigsty downloads all dependent packages from the Internet and creates local Yum repo during initialization. The total size of all the dependent software is about 1GB or so. Although Pigsty has tried to use mirror repos as much as possible to speed up …

    Pigsty downloads all dependent packages from the Internet and creates local Yum repo during initialization. The total size of all the dependent software is about 1GB or so. Although Pigsty has tried to use mirror repos as much as possible to speed up …

  • Backup and Recovery

    In Docs

    Historical DocsPIGSTY

    Backup & Recovery matters. Failures can be divided into two categories: hardware/resource failures and software/human errors. Replication aims for the former, while delayed replica & cold backups aim for the latter. Pigsty has complete support for …

    Backup & Recovery matters. Failures can be divided into two categories: hardware/resource failures and software/human errors. Replication aims for the former, while delayed replica & cold backups aim for the latter. Pigsty has complete support for …

  • Jupyter Lab

    In Docs

    Historical DocsPIGSTY

    TL;DR ./infra-jupyter.yml # install jupyter on meta node on port 8888 with user jupyter and password pigsty ./infra-jupyter.yml -e jupyter_port=8887 # use another port 8887 by default ./infra-jupyter.yml -e jupyter_username=osuser_jupyter …

    TL;DR ./infra-jupyter.yml # install jupyter on meta node on port 8888 with user jupyter and password pigsty ./infra-jupyter.yml -e jupyter_port=8887 # use another port 8887 by default ./infra-jupyter.yml -e jupyter_username=osuser_jupyter …

  • Upgrade Grafana Backend Database

    In Docs

    Historical DocsPIGSTY

    You can use postgres as the database used by the Grafana backend. In this tutorial, you will learn about the following. How to create a new cluster How to create a new biz user in an existing database cluster How to create a new biz database in an …

    You can use postgres as the database used by the Grafana backend. In this tutorial, you will learn about the following. How to create a new cluster How to create a new biz user in an existing database cluster How to create a new biz database in an …

  • Docker Applications

    In Docs

    Historical DocsPIGSTY

    Pigsty v1.5.1 comes with Docker and Docker Compose deployment support, where Docker Daemon will be enabled by default on the meta node. You can use Docker to deploy and launch software applications quickly. You can directly access the …

    Pigsty v1.5.1 comes with Docker and Docker Compose deployment support, where Docker Daemon will be enabled by default on the meta node. You can use Docker to deploy and launch software applications quickly. You can directly access the …

  • Install Applications

    In Docs

    Historical DocsPIGSTY

    Pigsty can be used to deploy and monitor PostgreSQL and make and distribute data Applications. Pigsty provides three sample applications. pglog, which analyzes PostgreSQL CSV log samples. covid, which visualizes WHO COVID-19 data and accesses country …

    Pigsty can be used to deploy and monitor PostgreSQL and make and distribute data Applications. Pigsty provides three sample applications. pglog, which analyzes PostgreSQL CSV log samples. covid, which visualizes WHO COVID-19 data and accesses country …

  • Alerting

    In Docs

    Historical DocsPIGSTY

    Pigsty uses Prometheus as the primary alerting system. Prometheus + AlertManager (primary) Grafana (backup), not enabled by default Alert Alerts are critical for daily fault response and improving system availability. Missing alarms will lead to …

    Pigsty uses Prometheus as the primary alerting system. Prometheus + AlertManager (primary) Grafana (backup), not enabled by default Alert Alerts are critical for daily fault response and improving system availability. Missing alarms will lead to …

  • Metrics

    In Docs

    Historical DocsPIGSTY

    Metric is the core concept of Pigsty’s monitor system. Format Metrics are formally cumulative, atomic logical units of measure that can be updated and statistically aggregated over periods. Metrics typically exist as time series with dimension …

    Metric is the core concept of Pigsty’s monitor system. Format Metrics are formally cumulative, atomic logical units of measure that can be updated and statistically aggregated over periods. Metrics typically exist as time series with dimension …

  • Service Discovery

    In Docs

    Historical DocsPIGSTY

    This article describes the mechanism used by the Pigsty monitor system Prometheus to discover monitor objects. The basis of service discovery is identity. For more identity information, please refer to the section entity. It would help if you also …

    This article describes the mechanism used by the Pigsty monitor system Prometheus to discover monitor objects. The basis of service discovery is identity. For more identity information, please refer to the section entity. It would help if you also …

  • Pigsty Dashboards

    In Docs

    Historical DocsPIGSTY

    Pigsty provides a professional and easy-to-use PostgreSQL monitor system that distills the industry’s monitoring best practices. The Pigsty monitoring dashboard consists of several relatively independent boards. Application Description Home Home …

    Pigsty provides a professional and easy-to-use PostgreSQL monitor system that distills the industry’s monitoring best practices. The Pigsty monitoring dashboard consists of several relatively independent boards. Application Description Home Home …

  • Customize: PGSQL

    In Docs

    Historical DocsPIGSTY

    The Patroni template is used to customize the specification config of the PostgreSQL cluster, while the Postgres template is used to customize the content of the PostgreSQL cluster. Pigsty provides nearly 100 parameters on PGSQL describing the …

    The Patroni template is used to customize the specification config of the PostgreSQL cluster, while the Postgres template is used to customize the content of the PostgreSQL cluster. Pigsty provides nearly 100 parameters on PGSQL describing the …

  • Config: REDIS

    In Docs

    Historical DocsPIGSTY

    Config Redis cluster and manipulate REDIS playbook behavior. Refer to Redis Deployment for details. REDIS_IDENTITY: REDIS Identity Params REDIS_NODE: REDIS Software, Dir & Exporter REDIS_PROVISION: REDIS Server Provisioning ID Name Section Type …

    Config Redis cluster and manipulate REDIS playbook behavior. Refer to Redis Deployment for details. REDIS_IDENTITY: REDIS Identity Params REDIS_NODE: REDIS Software, Dir & Exporter REDIS_PROVISION: REDIS Server Provisioning ID Name Section Type …

  • Config: PGSQL

    In Docs

    Historical DocsPIGSTY

    Use the PGSQL Playbook, and deploy the PGSQL cluster to adjust the cluster state to the state described in the PGSQL config. Pigsty has 100+ config parameters for describing a PostgreSQL cluster. However, users usually only need to care about a few …

    Use the PGSQL Playbook, and deploy the PGSQL cluster to adjust the cluster state to the state described in the PGSQL config. Pigsty has 100+ config parameters for describing a PostgreSQL cluster. However, users usually only need to care about a few …

  • Config: Nodes

    In Docs

    Historical DocsPIGSTY

    Pigsty provides host provisioning and monitoring functions. The nodes.yml playbook can be executed to configure the node to the corresponding state and incorporate it into the Pigsty monitor system. NODE_IDENTITY : Node identity parameters NODE_DNS: …

    Pigsty provides host provisioning and monitoring functions. The nodes.yml playbook can be executed to configure the node to the corresponding state and incorporate it into the Pigsty monitor system. NODE_IDENTITY : Node identity parameters NODE_DNS: …

  • Config: Infra

    In Docs

    Historical DocsPIGSTY

    Use the INFRA Playbook, and deploy the PGSQL cluster to adjust the cluster state to the state described in PGSQL Config. Use the INFRA series playbooks to configure the Pigsty infra. Infra config deals with such issues: localYum repos, machine node …

    Use the INFRA Playbook, and deploy the PGSQL cluster to adjust the cluster state to the state described in PGSQL Config. Use the INFRA series playbooks to configure the Pigsty infra. Infra config deals with such issues: localYum repos, machine node …

  • Configuration

    In Docs

    Historical DocsPIGSTY

    Pigsty uses declarative configuration. Pigsty defines infra and database clusters through Inventory, and each Pigsty deploy has a corresponding config. Pigsty’s config uses the “Infra as Data” philosophy: Users describe requirements through the …

    Pigsty uses declarative configuration. Pigsty defines infra and database clusters through Inventory, and each Pigsty deploy has a corresponding config. Pigsty’s config uses the “Infra as Data” philosophy: Users describe requirements through the …

  • Playbook: REDIS

    In Docs

    Historical DocsPIGSTY

    REDIS series Playbook: Define and pull Redis databases in traditional standalone, native, and sentinel clusters. Playbook Function Link redis Deploying a Redis database in Native/Standalone/Sentinel cluster src redis-remove Redis cluster/node …

    REDIS series Playbook: Define and pull Redis databases in traditional standalone, native, and sentinel clusters. Playbook Function Link redis Deploying a Redis database in Native/Standalone/Sentinel cluster src redis-remove Redis cluster/node …

  • Playbook: PGSQL

    In Docs

    Historical DocsPIGSTY

    Pull up a defined cluster of HA PostgreSQL cluster using the PGSQL series playbook. Overview Playbook Function Link pgsql Deploy a PostgreSQL cluster, or cluster expand src pgsql-remove Destroy PostgreSQL cluster, or cluster downsize src …

    Pull up a defined cluster of HA PostgreSQL cluster using the PGSQL series playbook. Overview Playbook Function Link pgsql Deploy a PostgreSQL cluster, or cluster expand src pgsql-remove Destroy PostgreSQL cluster, or cluster downsize src …

  • Playbook: NODES

    In Docs

    Historical DocsPIGSTY

    Use the NODES playbook to bring more nodes to Pigsty, adjusting nodes to the state described in the config. Once pigsty is installed on the meta node with infra.yml, You can add more nodes to Pigsty with nodes.yml or remove them from Pigsty with …

    Use the NODES playbook to bring more nodes to Pigsty, adjusting nodes to the state described in the config. Once pigsty is installed on the meta node with infra.yml, You can add more nodes to Pigsty with nodes.yml or remove them from Pigsty with …

  • Playbook: INFRA

    In Docs

    Historical DocsPIGSTY

    Install pigsty & Add new optional to meta node with INFRA series playbooks. Playbook Function Link infra Install pigsty on meta nodes src infra-demo Special version of infra, pull up the 4-node sandbox in one-pass src infra-remove Uninstall pigsty …

    Install pigsty & Add new optional to meta node with INFRA series playbooks. Playbook Function Link infra Install pigsty on meta nodes src infra-demo Special version of infra, pull up the 4-node sandbox in one-pass src infra-remove Uninstall pigsty …

  • Playbooks

    In Docs

    Historical DocsPIGSTY

    Learn about the pre-built playbooks provided by Pigsty, the features, how to use them, and the considerations. Pigsty implements core control functions at the bottom through the Ansible Playbook, and Pigsty provides pre-built playbooks in four main …

    Learn about the pre-built playbooks provided by Pigsty, the features, how to use them, and the considerations. Pigsty implements core control functions at the bottom through the Ansible Playbook, and Pigsty provides pre-built playbooks in four main …

  • MatrixDB Deployment

    In Docs

    Historical DocsPIGSTY

    Pigsty can be used to deploy and monitor MatrixDB (equal to Greenplum 7+ Time-Series database). Currently, MatrixDB uses PostgreSQL 12 kernel, while native Greenplum uses 9.6 kernels, so MatrixDB is used instead of Greenplum implementation, and …

    Pigsty can be used to deploy and monitor MatrixDB (equal to Greenplum 7+ Time-Series database). Currently, MatrixDB uses PostgreSQL 12 kernel, while native Greenplum uses 9.6 kernels, so MatrixDB is used instead of Greenplum implementation, and …

  • Redis Deployment

    In Docs

    Historical DocsPIGSTY

    Pigsty is a PostgreSQL distribution and a general-purpose application runtime. It can manage, deploy, and monitor other applications and databases, such as Redis. Similar to PostgreSQL, deploying Redis requires the same two steps. Declare/Define the …

    Pigsty is a PostgreSQL distribution and a general-purpose application runtime. It can manage, deploy, and monitor other applications and databases, such as Redis. Similar to PostgreSQL, deploying Redis requires the same two steps. Declare/Define the …

  • PostgreSQL Deployment

    In Docs

    Historical DocsPIGSTY

    This article describes several ways to deploy a PostgreSQL cluster using Pigsty: PGSQL-related playbook and config. Please refer to the related doc. Identity Parameters: Introduces the identity parameters required to define a standard PostgreSQL HA …

    This article describes several ways to deploy a PostgreSQL cluster using Pigsty: PGSQL-related playbook and config. Please refer to the related doc. Identity Parameters: Introduces the identity parameters required to define a standard PostgreSQL HA …

  • Monitoring System

    In Docs

    Historical DocsPIGSTY

    How to use Pigsty to monitor existing PostgreSQL instances? For existing Pigsty instances that Pigsty does not create, some additional configuration is required if they are monitored using Pigsty’s monitoring system. TL; DR Create the monitoring …

    How to use Pigsty to monitor existing PostgreSQL instances? For existing Pigsty instances that Pigsty does not create, some additional configuration is required if they are monitored using Pigsty’s monitoring system. TL; DR Create the monitoring …

  • Sandbox

    In Docs

    Historical DocsPIGSTY

    Pigsty supports both local sandbox and cloud sandbox for quickly preparing a standard 1/4 node demo environment locally or in the cloud. Pigsty provides a sandbox environment. Ultimately creating and running through the sandbox installation and …

    Pigsty supports both local sandbox and cloud sandbox for quickly preparing a standard 1/4 node demo environment locally or in the cloud. Pigsty provides a sandbox environment. Ultimately creating and running through the sandbox installation and …

  • Preparation

    In Docs

    Historical DocsPIGSTY

    How to prepare the resources required for Pigsty deployment. Node Provisioning Meta Provisioning Admin Provisioning Software Provisioning Pigsty source code Pigsty offline package Vagrant (sandbox) Virtualbox (sandbox) Node Provisioning Before …

    How to prepare the resources required for Pigsty deployment. Node Provisioning Meta Provisioning Admin Provisioning Software Provisioning Pigsty source code Pigsty offline package Vagrant (sandbox) Virtualbox (sandbox) Node Provisioning Before …

  • Pigsty Deployment

    In Docs

    Historical DocsPIGSTY

    It takes three steps to deploy Pigsty: Prepare, Configure, Playbook. Preparation Before installing Pigsty, you need to prepare the required resources: physical/VM nodes, admin users, and download Pigsty software. Node provisioning Meta node …

    It takes three steps to deploy Pigsty: Prepare, Configure, Playbook. Preparation Before installing Pigsty, you need to prepare the required resources: physical/VM nodes, admin users, and download Pigsty software. Node provisioning Meta node …

  • PGSQL Authentication and Privilege

    In Docs

    Historical DocsPIGSTY

    PostgreSQL provides a standard access control mechanism: Authentication and Privileges, both of which are based on the Role system. Role Pigsty’s default role system contains four default roles and four default users: name attr roles desc …

    PostgreSQL provides a standard access control mechanism: Authentication and Privileges, both of which are based on the Role system. Role Pigsty’s default role system contains four default roles and four default users: name attr roles desc …

  • PGSQL Authentication and Privilege

    In Docs

    Historical DocsPIGSTY

    PostgreSQL provides a standard access control mechanism: Authentication and Privileges, both of which are based on the Role system. Role Pigsty’s default role system contains four default roles and four default users: name attr roles desc …

    PostgreSQL provides a standard access control mechanism: Authentication and Privileges, both of which are based on the Role system. Role Pigsty’s default role system contains four default roles and four default users: name attr roles desc …

  • PGSQL Service & Access

    In Docs

    Historical DocsPIGSTY

    Defining PostgreSQL service and achieving stable, reliable, and HA access through LB and connection pooling. The concepts of Service and Access are proposed for HA PostgreSQL clusters. Personal User After completing the singleton deployment, port …

    Defining PostgreSQL service and achieving stable, reliable, and HA access through LB and connection pooling. The concepts of Service and Access are proposed for HA PostgreSQL clusters. Personal User After completing the singleton deployment, port …

  • Concept: Redis

    In Docs

    Historical DocsPIGSTY

    This article introduces the core concepts required for Redis cluster management. Deploy: Redis |Config: Redis | Playbook: Redis ER Model The Redis entity concept model is almost identical to PostgreSQL and includes the Cluster and Instance. Note …

    This article introduces the core concepts required for Redis cluster management. Deploy: Redis |Config: Redis | Playbook: Redis ER Model The Redis entity concept model is almost identical to PostgreSQL and includes the Cluster and Instance. Note …

  • Concept: PGSQL

    In Docs

    Historical DocsPIGSTY

    This article introduces the core concepts required for PostgreSQL cluster management. PGSQL Cluster / ER Model / Identity Parameter Cluster / Instance / Node / Service PostgreSQL HA Deploy: PGSQL |Config: PGSQL | Playbook: PGSQL | Custom: PGSQL …

    This article introduces the core concepts required for PostgreSQL cluster management. PGSQL Cluster / ER Model / Identity Parameter Cluster / Instance / Node / Service PostgreSQL HA Deploy: PGSQL |Config: PGSQL | Playbook: PGSQL | Custom: PGSQL …

  • Concept: Nodes

    In Docs

    Historical DocsPIGSTY

    Pigsty use nodes for deployment, nodes cloud be physical machines, VMs, or even Pods. Pigsty has two types of nodes: meta node and (normal) node. Meta nodes are used to initiate control, and (normal) nodes are managed under control. Meta node: Run …

    Pigsty use nodes for deployment, nodes cloud be physical machines, VMs, or even Pods. Pigsty has two types of nodes: meta node and (normal) node. Meta nodes are used to initiate control, and (normal) nodes are managed under control. Meta node: Run …

  • Infrastructure

    In Docs

    Historical DocsPIGSTY

    Pigsty provides a complete, battery-included PaaS infra. Pigsty, as a battery-included PaaS solution, will integrate the basic infra into the provisioning solution. Overview Pigsty deploys a complete set of infra on meta nodes (the currently …

    Pigsty provides a complete, battery-included PaaS infra. Pigsty, as a battery-included PaaS solution, will integrate the basic infra into the provisioning solution. Overview Pigsty deploys a complete set of infra on meta nodes (the currently …

  • Architecture

    In Docs

    Historical DocsPIGSTY

    Pigsty consists of several modules that can be combined according to different scenarios. Module Pigsty currently offers four modules. INFRA is Pigsty’s infrastructure module, including monitoring/alerting/visualization/logging/DNS/NTP components. …

    Pigsty consists of several modules that can be combined according to different scenarios. Module Pigsty currently offers four modules. INFRA is Pigsty’s infrastructure module, including monitoring/alerting/visualization/logging/DNS/NTP components. …

  • Concepts

    In Docs

    Historical DocsPIGSTY

    Index Module Concept Deploy Config Playbook INFRA Concept: INFRA Deploy: INFRA Config: INFRA Playbook: INFRA NODES Concept: NODES Deploy: NODES Config: NODES Playbook: NODES PGSQL Concept: PGSQL Deploy: PGSQL Config: PGSQL Playbook: PGSQL REDIS …

    Index Module Concept Deploy Config Playbook INFRA Concept: INFRA Deploy: INFRA Config: INFRA Playbook: INFRA NODES Concept: NODES Deploy: NODES Config: NODES Playbook: NODES PGSQL Concept: PGSQL Deploy: PGSQL Config: PGSQL Playbook: PGSQL REDIS …

  • FAQ: Frequently Asked Questions

    In Docs

    Historical DocsPIGSTY

    Here are some frequently asked questions. If you have some unlisted questions, Contact Us, or submit an Issue. Preparation Download Configuration Installation Sandbox Monitoring INFRA NODES PGSQL Preparation It would help if you ensured that the …

    Here are some frequently asked questions. If you have some unlisted questions, Contact Us, or submit an Issue. Preparation Download Configuration Installation Sandbox Monitoring INFRA NODES PGSQL Preparation It would help if you ensured that the …

  • Features

    In Docs

    Historical DocsPIGSTY

    The battery-include, auto-piloting, handy & thrifty distribution for open-source databases. Battery-Include Open-Source Postgres Distribution Auto-Piloting monitoring and management SRE Solution Easy-to-use Database-as-Code Developer Toolbox Safe & …

    The battery-include, auto-piloting, handy & thrifty distribution for open-source databases. Battery-Include Open-Source Postgres Distribution Auto-Piloting monitoring and management SRE Solution Easy-to-use Database-as-Code Developer Toolbox Safe & …

  • Installation

    In Docs

    Historical DocsPIGSTY

    It takes 3 steps to install Pigsty: Prepare, Configure, Execute Playbook There are two typical modes: Singleton & Cluster Management Singleton Meta: Install pigsty on one single meta node. (for PostgreSQL dev/test, RDS monitoring, etc…) Cluster …

    It takes 3 steps to install Pigsty: Prepare, Configure, Execute Playbook There are two typical modes: Singleton & Cluster Management Singleton Meta: Install pigsty on one single meta node. (for PostgreSQL dev/test, RDS monitoring, etc…) Cluster …

  • Introduction

    In Docs

    Historical DocsPIGSTY

    Different users have different concerns. If you encounter problems, you are welcome to check the FAQ, submit an Issue, or ask the Community for help. Beginners Beginners can visit the Pigsty demo site: http://demo.pigsty.cc for a quick glance. There …

    Different users have different concerns. If you encounter problems, you are welcome to check the FAQ, submit an Issue, or ask the Community for help. Beginners Beginners can visit the Pigsty demo site: http://demo.pigsty.cc for a quick glance. There …

  • Pigsty v1.5.1 Documentation

    In Docs

    Historical DocsPIGSTY

    Pigsty v1.5.1 Documentation Battery-Included Open-Source PostgreSQL Distribution Latest Version: v1.5.1 | Github Repo | Demo Documentation: EN Docs | 中文文档 | Github Pages What is Pigsty? Pigsty is battery-included open-source database distribution, …

    Pigsty v1.5.1 Documentation Battery-Included Open-Source PostgreSQL Distribution Latest Version: v1.5.1 | Github Repo | Demo Documentation: EN Docs | 中文文档 | Github Pages What is Pigsty? Pigsty is battery-included open-source database distribution, …