# Introduction

> Historical documentation restored from the Pigsty v1.5.1 tag.
---

> Different users have different concerns. If you encounter problems, you are welcome to check the [FAQ](/docs/s-faq/), submit an [Issue](https://github.com/Vonng/pigsty/issues/new), or ask the [Community](/docs/community/) for help.



## Beginners

Beginners can visit the Pigsty demo site: [http://demo.pigsty.cc](http://demo.pigsty.cc) for a quick glance.

There are several [data applications](/docs/t-application/) that are built upon Pigsty to illustrate this distribution: [`pglog`](http://demo.pigsty.cc/d/pglog-overview), [`covid`](http://demo.pigsty.cc/d/covid-overview), [`isd`](http://demo.pigsty.cc/d/isd-overview), [`dbeng`](http://demo.pigsty.cc/d/dbeng-overview), [`worktime`](http://demo.pigsty.cc/d/worktime-query).

You can also deploy SaaS software with [docker](/docs/t-docker/) and get production-grade durability with an external pigsty database.



## Developer

Developers are more concerned about the fastest way to [download](/docs/d-prepare/), [install](/docs/s-install/) and [access](/docs/c-service/#access) the database, please refer to [Installation](/docs/s-install/).

Pigsty aims at simplicity: you can launch pigsty on fresh CentOS 7.8 nodes with one command [without](/docs/t-offline/) Internet Access.

Pigsty provides  [Vagrant](/docs/d-sandbox/#local-sandbox) & [Terraform](/docs/d-sandbox/#cloud-sandbox) templates for pulling up 4 VMs with one click to deploy a [sandbox](/docs/d-sandbox/) on a local x86 laptop/PC or cloud. Users can also [prepare](/docs/d-prepare/) VMs, cloud VMs, or physical machines for the standard [deployment](/docs/d-deploy/) process.

The user can [access](/docs/c-service/#access) database [service](/docs/c-service/) through connstr, and perform essential operation tasks with [SOP](/docs/r-sop/).

For a deeper understanding of Pigsty's design and architecture, you can refer to the [concept](/docs/c-concept/) chapter.

* [Architecture](/docs/c-arch/)
* [Infrastructure](/docs/c-infra/)
* [Meta Node](/docs/c-nodes/) & [Node](/docs/c-nodes/#node)
* [PGSQL Cluster](/docs/c-pgsql/)
* [PGSQL Service](/docs/c-service/#service) / [PGSQL Access](/docs/c-service/#access)
* [PGSQL Privilege](/docs/c-privilege/#privilege) / [PGSQL Authentication](/docs/c-privilege/#authentication)
* [PGSQL Biz User](/docs/c-pgdbuser/) / [PGSQL BIZ DB](/docs/c-pgdbuser/#database-privileges)



## Operators

Operators are more concerned with the details of the deployment. The following tutorials provide the details of Pigsty's installation and deployment.

   * [Pigsty Deployment](/docs/d-deploy/)
   * [Pigsty Preparation](/docs/d-prepare/)
   * [Offline Installation](/docs/t-offline/)
   * [Infra Init](/docs/p-infra/)
   * [PostgreSQL Init](/docs/p-pgsql/)
   * [Redis Init](/docs/p-redis/)

The tutorial [Grafana Backend Database Upgrade](/docs/t-grafana-upgrade/) shows a complete and representative example of preparing a Postgres cluster exclusively for Grafana.





## DBA

DBAs are usually more concerned with the usage of monitoring systems and the specific ways in which they are maintained daily.

DBAs are more concerned with the usage of monitoring systems and the way of daily maintenance.

#### Monitoring System Tutorial

- [Introduction of Monitoring Metrics](/docs/m-metric/)
- [Introduction of Monitoring Dashboard](/docs/m-dashboard/)
- [Introduction of Alerting System](/docs/r-alert/)
- [Service Discovery Mechanism](/docs/m-discovery/)
- [Analysis of CSVLOG](/docs/t-application/#pglog-csvlog-sample-analysis)


#### Daily maintenance management

- [Cluster Create/Expand](/docs/r-sop/#case-1-cluster-create-and-expand)
- [Cluster Destruction/Downsize](/docs/r-sop/#case-2-cluster-destruction-and-downsize)
- [Cluster Config Change/Restart](/docs/r-sop/#case-3-cluster-config-change-and-restart)
- [Create PGSQL BIZ User](/docs/r-sop/#case-4-create-pgsql-biz-user)
- [Create PGSQL BIZ DB](/docs/r-sop/#case-5-create-pgsql-biz-db)
- [Apply PGSQL HBA](/docs/r-sop/#case-6-apply-pgsql-hba)
- [PGSQL LB Traffic Control](/docs/r-sop/#case-7-pgsql-lb-traffic-control)
- [PGSQL Role Adjustment](/docs/r-sop/#case-8-pgsql-role-adjustment)
- [Monitor Targets](/docs/r-sop/#case-9-monitor-targets)
- [Cluster Switchover](/docs/r-sop/#case-10-cluster-switchover)
- [Reset Component](/docs/r-sop/#case-11-reset-component)
- [Switching DCS Servers](/docs/r-sop/#case-12-switching-dcs-servers)



## Professional

For professional users (deep customization, secondary development), Pigsty provides a rich [config entry](/docs/v-config/#config-entry) with a customization interface.