Skip to content

Module: INFRA

  • Grafana High Availability: Using PostgreSQL Backend

    In Administration

    TaskINFRA

    You can use PostgreSQL as Grafana’s backend database. This is a great opportunity to understand Pigsty’s deployment system. By completing this tutorial, you’ll learn: How to create a new database cluster How to create new business users in an …

    You can use PostgreSQL as Grafana’s backend database. This is a great opportunity to understand Pigsty’s deployment system. By completing this tutorial, you’ll learn: How to create a new database cluster How to create new business users in an …

  • Metrics

    In Module: INFRA

    ReferenceINFRA

    Note: Pigsty v4.0 has replaced Prometheus/Loki with VictoriaMetrics/Logs/Traces. The following metric list is still based on v3.x generation, for reference when troubleshooting older versions only. To get the latest metrics, query directly in …

    Note: Pigsty v4.0 has replaced Prometheus/Loki with VictoriaMetrics/Logs/Traces. The following metric list is still based on v3.x generation, for reference when troubleshooting older versions only. To get the latest metrics, query directly in …

  • Encrypted Communication

    In Security

    ConceptPIGSTYINFRAPGSQL

    TLS can provide three separate protections: transport encryption, server authentication, and client authentication. Each must be configured independently. Enabling server-side TLS does not mean the client verifies the server identity, nor does it …

    TLS can provide three separate protections: transport encryption, server authentication, and client authentication. Each must be configured independently. Enabling server-side TLS does not mean the client verifies the server identity, nor does it …

  • Monitoring System

    In Concepts

    ConceptINFRA

    Pigsty’s monitoring system has three pillars—metrics, logs, and alerting—and is available out of the box. Logs and alerts are also important inputs for audit and traceability. It can monitor clusters managed by Pigsty, existing PostgreSQL clusters, …

    Pigsty’s monitoring system has three pillars—metrics, logs, and alerting—and is available out of the box. Logs and alerts are also important inputs for audit and traceability. It can monitor clusters managed by Pigsty, existing PostgreSQL clusters, …

  • Infrastructure

    In Architecture

    ConceptINFRA

    Running production-grade, highly available PostgreSQL clusters typically requires a comprehensive set of infrastructure services (foundation) for support, such as monitoring and alerting, log collection, time synchronization, DNS resolution, and …

    Running production-grade, highly available PostgreSQL clusters typically requires a comprehensive set of infrastructure services (foundation) for support, such as monitoring and alerting, log collection, time synchronization, DNS resolution, and …

  • Comparison

    In Comparison

    ReferenceINFRA

    Comparison with RDS Pigsty is a local-first RDS alternative released under Apache-2.0, deployable on your own physical/virtual machines or cloud servers. We’ve chosen Amazon AWS RDS for PostgreSQL (the global market leader) and Alibaba Cloud RDS for …

    Comparison with RDS Pigsty is a local-first RDS alternative released under Apache-2.0, deployable on your own physical/virtual machines or cloud servers. We’ve chosen Amazon AWS RDS for PostgreSQL (the global market leader) and Alibaba Cloud RDS for …

  • E-R Model of Infra Cluster

    In ER Model

    ConceptINFRA

    The INFRA module plays a special role in Pigsty: it’s not a traditional “cluster” but rather a management hub composed of a group of infrastructure nodes, providing core services for the entire Pigsty deployment. Each INFRA node is an autonomous …

    The INFRA module plays a special role in Pigsty: it’s not a traditional “cluster” but rather a management hub composed of a group of infrastructure nodes, providing core services for the entire Pigsty deployment. Each INFRA node is an autonomous …