Playbooks

Built-in playbooks to perform various tasks

Pigsty uses a declarative interface, [configuration](. /config/) is done, just run the fixed Playbook and you’re done deploying

Basic Deployment

infrastructure initialization: in [meta-node](. /… /concept/arch/# meta-node) required to deploy Pigsty on [infrastructure](. /… /concept/arch/#infrastructure): infra.yml
database cluster initialization: in [database nodes](. /… /concept/arch/#database node) to deploy highly available PostgreSQL [database cluster](. /… /concept/arch/#database cluster) : pgsql.yml

sandbox deployment: for local sandbox environments, Pigsty provides a quick initialization script using interleaved deployment: [sandbox.yml](https://github.com/Vonng/pigsty/blob/master/sandbox. yml)

monitor-only deployment: For scenarios where only monitoring of the system is required, Pigsty provides a dedicated script for monitoring-only deployment: [pgsql-monitor.yml](https://github.com/Vonng/pigsty/blob/master/ pgsql-monitor.yml)

Pigsty also provides a number of pre-built scripts for daily operations and maintenance management.

database offline: you can remove an existing database cluster or instance and recycle nodes: [pgsql-remove.yml](https://github.com/Vonng/pigsty/blob/master/pgsql- remove.yml)
create business database: you can create a new database in an existing cluster or modify an existing database: [pgsql-createdb.yml](https://github.com/Vonng/pigsty/blob/master/ pgsql-createdb.yml)
create business database: You can create new users or modify existing users in an existing cluster: [pgsql-createuser.yml](https://github.com/Vonng/pigsty/blob/master/ pgsql-createuser.yml)
create service: you can create or modify service in an existing cluster: [pgsql-service.yml](https://github.com/Vonng/pigsty/blob/master/pgsql-service. yml)