文档 v1.5.1 版本已不再积极维护，你当前浏览的是一份归档快照。 最新文档请参阅 最新版本。
目录结构
从 Pigsty v1.5.1 标签恢复的历史文档。
Pigsty目录结构
#------------------------------------------------------------------------------
# pigsty
# ^-----@app # extra demo application resources
# ^-----@bin # bin scripts
# ^-----@docs # document (can be docsified)
# ^-----@files # ansible file resources
# ^-----@conf # config template files
# ^-----@rule # soft link to prometheus rules
# ^-----@ui # soft link to grafana dashboards
# ^-----@roles # ansible business logic
# ^-----@templates # ansible templates
# ^-----@vagrant # sandbox resources
# ^-----configure # configure wizard script
# ^-----ansible.cfg # default ansible config file
# ^-----pigsty.yml # default config file
# ^-----*.yml # ansible playbooks
#------------------------------------------------------------------------------
# /etc/pigsty/
# ^-----@targets # file based service discovery targets definition
# ^-----@dashboards # static grafana dashboards
# ^-----@datasources # static grafana datasources
# ^-----@playbooks # extra ansible playbooks
#------------------------------------------------------------------------------Prometheus目录结构
#------------------------------------------------------------------------------
# Config FHS
#------------------------------------------------------------------------------
# /etc/prometheus/
# ^-----prometheus.yml # prometheus main config file
# ^-----alertmanager.yml # alertmanger main config file
# ^-----@bin # util scripts: check,reload,status,new
# ^-----@rules # record & alerting rules definition
# ^-----@infra # infrastructure rules & alert
# ^-----@nodes # nodes rules & alert
# ^-----@pgsql # pgsql rules & alert
# ^-----@redis # redis rules & alert
# ^-----@.......... # etc...
# ^-----@targets # file based service discovery targets definition
# ^-----@infra # infra static targets definition
# ^-----@nodes # nodes static targets definition
# ^-----@pgsql # pgsql static targets definition
# ^-----@redis # redis static targets definition
# ^-----@..... # other targets
#------------------------------------------------------------------------------Postgres目录结构
以下参数与PostgreSQL数据库目录相关
- pg_dbsu_home：Postgres默认用户的家目录，默认为
/var/lib/pgsql - pg_bin_dir：Postgres二进制目录，默认为
/usr/pgsql/bin/ - pg_data：Postgres数据库目录，默认为
/pg/data - pg_fs_main：Postgres主数据盘挂载点，默认为
/export - pg_fs_bkup：Postgres备份盘挂载点，默认为
/var/backups（可选，也可以选择备份到主数据盘上的子目录）
#------------------------------------------------------------------------------
# Create Directory
#------------------------------------------------------------------------------
# this assumes that
# /pg is shortcut for postgres home
# {{ pg_fs_main }} contains the main data (MUST ALREADY MOUNTED)
# {{ pg_fs_bkup }} contains archive and backup data (MUST ALREADY MOUNTED)
# cluster-version is the default parent folder for pgdata (e.g pg-test-12)
#------------------------------------------------------------------------------
# default variable:
# pg_fs_main = /export fast ssd
# pg_fs_bkup = /var/backups cheap hdd
#
# /pg -> /export/postgres/pg-test-12
# /pg/data -> /export/postgres/pg-test-12/data
#------------------------------------------------------------------------------
- name: Create postgresql directories
tags: pg_dir
become: yes
block:
- name: Make sure main and backup dir exists
file: path={{ item }} state=directory owner=root mode=0777
with_items:
- "{{ pg_fs_main }}"
- "{{ pg_fs_bkup }}"
# pg_cluster_dir: "{{ pg_fs_main }}/postgres/{{ pg_cluster }}-{{ pg_version }}"
- name: Create postgres directory structure
file: path={{ item }} state=directory owner={{ pg_dbsu }} group=postgres mode=0700
with_items:
- "{{ pg_fs_main }}/postgres"
- "{{ pg_cluster_dir }}"
- "{{ pg_cluster_dir }}/bin"
- "{{ pg_cluster_dir }}/log"
- "{{ pg_cluster_dir }}/tmp"
- "{{ pg_cluster_dir }}/conf"
- "{{ pg_cluster_dir }}/data"
- "{{ pg_cluster_dir }}/meta"
- "{{ pg_cluster_dir }}/stat"
- "{{ pg_cluster_dir }}/change"
- "{{ pg_backup_dir }}/postgres"
- "{{ pg_backup_dir }}/arcwal"
- "{{ pg_backup_dir }}/backup"
- "{{ pg_backup_dir }}/remote"PG二进制目录结构
在RedHat/CentOS上，默认的Postgres发行版安装位置为
/usr/pgsql-${pg_version}/安装剧本会自动创建指向当前安装版本的软连接，例如，如果安装了14版本的Postgres，则有：
/usr/pgsql -> /usr/pgsql-14因此，默认的pg_bin_dir为/usr/pgsql/bin/，该路径会在/etc/profile.d/pgsql.sh中添加至所有用户的PATH环境变量中。
PG数据目录结构
Pigsty假设用于部署数据库实例的单个节点上至少有一块主数据盘（pg_fs_main），以及一块可选的备份数据盘（pg_fs_bkup）。通常主数据盘是高性能SSD，而备份盘是大容量廉价HDD。
#------------------------------------------------------------------------------
# Create Directory
#------------------------------------------------------------------------------
# this assumes that
# /pg is shortcut for postgres home
# {{ pg_fs_main }} contains the main data (MUST ALREADY MOUNTED)
# {{ pg_fs_bkup }} contains archive and backup data (MAYBE ALREADY MOUNTED)
# {{ pg_cluster }}-{{ pg_version }} is the default parent folder
# for pgdata (e.g pg-test-14)
#------------------------------------------------------------------------------
# default variable:
# pg_fs_main = /export fast ssd
# pg_fs_bkup = /var/backups cheap hdd
#
# /pg -> /export/postgres/pg-test-14
# /pg/data -> /export/postgres/pg-test-14/dataPG数据库集簇目录结构
# basic
{{ pg_fs_main }} /data # contains all business data (pg,consul,etc..)
{{ pg_dir_main }} /data/postgres # contains postgres main data
{{ pg_cluster_dir }} /data/postgres/pg-test-14 # contains cluster `pg-test` data (of version 13)
/data/postgres/pg-test-14/bin # binary scripts
/data/postgres/pg-test-14/log # misc logs
/data/postgres/pg-test-14/tmp # tmp, sql files, records
/data/postgres/pg-test-14/conf # configurations
/data/postgres/pg-test-14/data # main data directory
/data/postgres/pg-test-14/meta # identity information
/data/postgres/pg-test-14/stat # stats information
/data/postgres/pg-test-14/change # changing records
{{ pg_fs_bkup }} /var/backups # contains all backup data (pg,consul,etc..)
{{ pg_dir_bkup }} /var/backups/postgres # contains postgres backup data
{{ pg_backup_dir }} /var/backups/postgres/pg-test-14 # contains cluster `pg-test` backup (of version 13)
/var/backups/postgres/pg-test-14/backup # base backup
/var/backups/postgres/pg-test-14/arcwal # WAL archive
/var/backups/postgres/pg-test-14/remote # mount NFS/S3 remote resources here
# links
/pg -> /data/postgres/pg-test-14 # pg root link
/pg/data -> /data/postgres/pg-test-14/data # real data dir
/pg/backup -> /var/backups/postgres/pg-test-14/backup # base backup
/pg/arcwal -> /var/backups/postgres/pg-test-14/arcwal # WAL archive
/pg/remote -> /var/backups/postgres/pg-test-14/remote # mount NFS/S3 remote resources herePgbouncer配置文件结构
Pgbouncer使用Postgres用户运行，配置文件位于/etc/pgbouncer。配置文件包括：
pgbouncer.ini，主配置文件userlist.txt：列出连接池中的用户pgb_hba.conf：列出连接池用户的访问权限database.txt：列出连接池中的数据库
Redis文件结构
Pigsty提供了对Redis部署与监控对基础支持。
Redis二进制使用RPM包或复制二进制的方式安装于/bin/中，包括
redis-server
redis-server
redis-cli
redis-sentinel
redis-check-rdb
redis-check-aof
redis-benchmark
/usr/libexec/redis-shutdown对于一个名为 redis-test-1-6379 的 Redis 实例，与其相关的资源如下所示：
/usr/lib/systemd/system/redis-test-1-6379.service # 服务
/etc/redis/redis-test-1-6379.conf # 配置
/data/redis/redis-test-1-6379 # 数据库目录
/data/redis/redis-test-1-6379/redis-test-1-6379.rdb # RDB文件
/data/redis/redis-test-1-6379/redis-test-1-6379.aof # AOF文件
/var/log/redis/redis-test-1-6379.log # 日志
/var/run/redis/redis-test-1-6379.pid # PID