Version v2.7.0 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.
Category: Concept
-
Access Control
Pigsty has a battery-included access control model based on Role System and Privileges. Role System Pigsty has a default role system consist of four default roles and four default users： Role name Attributes Member of Description dbrole_readonly …
Pigsty has a battery-included access control model based on Role System and Privileges. Role System Pigsty has a default role system consist of four default roles and four default users： Role name Attributes Member of Description dbrole_readonly …
-
Access Control
Pigsty has a battery-included access control model based on Role System and Privileges. Role System Pigsty has a default role system consist of four default roles and four default users： Role name Attributes Member of Description dbrole_readonly …
Pigsty has a battery-included access control model based on Role System and Privileges. Role System Pigsty has a default role system consist of four default roles and four default users： Role name Attributes Member of Description dbrole_readonly …
-
High Availability
Overview Primary Failure RTO ≈ 30s, RPO < 1MB, Replica Failure RTO≈0 (reset current conn) Pigsty’s PostgreSQL cluster has battery-included high-availability powered by Patroni, Etcd, and HAProxy When your have two or more instances in the PostgreSQL …
Overview Primary Failure RTO ≈ 30s, RPO < 1MB, Replica Failure RTO≈0 (reset current conn) Pigsty’s PostgreSQL cluster has battery-included high-availability powered by Patroni, Etcd, and HAProxy When your have two or more instances in the PostgreSQL …
-
Self-Signed CA
Pigsty has some security best practices: encrypting network traffic with SSL and encrypting the Web interface with HTTPS. To achieve this, Pigsty comes with a built-in local self-signed Certificate Authority (CA) for issuing SSL certificates to …
Pigsty has some security best practices: encrypting network traffic with SSL and encrypting the Web interface with HTTPS. To achieve this, Pigsty comes with a built-in local self-signed Certificate Authority (CA) for issuing SSL certificates to …
-
Authentication
Host-Based Authentication in Pigsty PostgreSQL has various authentication methods. You can use all of them, while pigsty’s battery-include ACL system focuses on HBA, password, and SSL authentication. Client Authentication To connect to a PostgreSQL …
Host-Based Authentication in Pigsty PostgreSQL has various authentication methods. You can use all of them, while pigsty’s battery-include ACL system focuses on HBA, password, and SSL authentication. Client Authentication To connect to a PostgreSQL …
-
Extensions
Extensions are the soul of PostgreSQL, and Pigsty deeply integrates the core extension plugins of the PostgreSQL ecosystem, providing you with battery-included distributed temporal, geospatial text, graph, and vector database capabilities! Check …
Extensions are the soul of PostgreSQL, and Pigsty deeply integrates the core extension plugins of the PostgreSQL ecosystem, providing you with battery-included distributed temporal, geospatial text, graph, and vector database capabilities! Check …
-
Services
Split read & write, route traffic to the right place, and achieve stable & reliable access to the PostgreSQL cluster. Service is an abstraction to seal the details of the underlying cluster, especially during cluster failover/switchover. Personal …
Split read & write, route traffic to the right place, and achieve stable & reliable access to the PostgreSQL cluster. Service is an abstraction to seal the details of the underlying cluster, especially during cluster failover/switchover. Personal …
-
Databases
In this context, Database refers to the object created by SQL CREATE DATABASE. A PostgreSQL server can serve multiple databases simultaneously. And you can customize each database with Pigsty API. Define Database Business databases are defined by …
In this context, Database refers to the object created by SQL CREATE DATABASE. A PostgreSQL server can serve multiple databases simultaneously. And you can customize each database with Pigsty API. Define Database Business databases are defined by …
-
Users
In this context, the User refers to objects created by SQL CREATE USER/ROLE. Define User There are two parameters related to users: pg_users : Define business users & roles at cluster level pg_default_roles : Define system-wide roles & global users …
In this context, the User refers to objects created by SQL CREATE USER/ROLE. Define User There are two parameters related to users: pg_users : Define business users & roles at cluster level pg_default_roles : Define system-wide roles & global users …
-
Architecture
Modular Architecture and Declarative Interface! Pigsty deployment is described by config inventory and materialized with ansible playbooks. Pigsty works on Linux x86_64 common nodes, i.e., bare metals or virtual machines. Pigsty uses a modular …
Modular Architecture and Declarative Interface! Pigsty deployment is described by config inventory and materialized with ansible playbooks. Pigsty works on Linux x86_64 common nodes, i.e., bare metals or virtual machines. Pigsty uses a modular …