Parameters
Parameter reference for Pigsty
| ID | Name | Module | Section | Type | Level | Comment |
|---|---|---|---|---|---|---|
| 101 | version | INFRA | META | string | G | pigsty version string |
| 102 | admin_ip | INFRA | META | ip | G | admin node ip address |
| 103 | region | INFRA | META | enum | G | upstream mirror region: default,china,europe |
| 104 | proxy_env | INFRA | META | dict | G | global proxy env when downloading packages |
| 105 | ca_method | INFRA | CA | enum | G | create,recreate,copy, create by default |
| 106 | ca_cn | INFRA | CA | string | G | ca common name, fixed as pigsty-ca |
| 107 | cert_validity | INFRA | CA | interval | G | cert validity, 20 years by default |
| 108 | infra_seq | INFRA | INFRA_ID | int | I | infra node identity, REQUIRED |
| 109 | infra_portal | INFRA | INFRA_ID | dict | G | infra services exposed via portal |
| 110 | repo_enabled | INFRA | REPO | bool | G/I | create a yum repo on this infra node? |
| 111 | repo_home | INFRA | REPO | path | G | repo home dir, /www by default |
| 112 | repo_name | INFRA | REPO | string | G | repo name, pigsty by default |
| 113 | repo_endpoint | INFRA | REPO | url | G | access point to this repo by domain or ip:port |
| 114 | repo_remove | INFRA | REPO | bool | G/A | remove existing upstream repo |
| 115 | repo_upstream | INFRA | REPO | upstream[] | G | where to download upstream packages |
| 116 | repo_packages | INFRA | REPO | string[] | G | which packages to be included |
| 117 | repo_url_packages | INFRA | REPO | string[] | G | extra packages from url |
| 118 | infra_packages | INFRA | INFRA_PACKAGE | string[] | G | packages to be installed on infra nodes |
| 119 | infra_packages_pip | INFRA | INFRA_PACKAGE | string | G | pip installed packages for infra nodes |
| 120 | nginx_enabled | INFRA | NGINX | bool | G/I | enable nginx on this infra node? |
| 121 | nginx_sslmode | INFRA | NGINX | enum | G | nginx ssl mode? disable,enable,enforce |
| 122 | nginx_home | INFRA | NGINX | path | G | nginx content dir, /www by default |
| 123 | nginx_port | INFRA | NGINX | port | G | nginx listen port, 80 by default |
| 124 | nginx_ssl_port | INFRA | NGINX | port | G | nginx ssl listen port, 443 by default |
| 125 | nginx_navbar | INFRA | NGINX | index[] | G | nginx index page navigation links |
| 126 | dns_enabled | INFRA | DNS | bool | G/I | setup dnsmasq on this infra node? |
| 127 | dns_port | INFRA | DNS | port | G | dns server listen port, 53 by default |
| 128 | dns_records | INFRA | DNS | string[] | G | dynamic dns records resolved by dnsmasq |
| 129 | prometheus_enabled | INFRA | PROMETHEUS | bool | G/I | enable prometheus on this infra node? |
| 130 | prometheus_clean | INFRA | PROMETHEUS | bool | G/A | clean prometheus data during init? |
| 131 | prometheus_data | INFRA | PROMETHEUS | path | G | prometheus data dir, /data/prometheus by default |
| 132 | prometheus_sd_interval | INFRA | PROMETHEUS | interval | G | prometheus target refresh interval, 5s by default |
| 133 | prometheus_scrape_interval | INFRA | PROMETHEUS | interval | G | prometheus scrape & eval interval, 10s by default |
| 134 | prometheus_scrape_timeout | INFRA | PROMETHEUS | interval | G | prometheus global scrape timeout, 8s by default |
| 135 | prometheus_options | INFRA | PROMETHEUS | arg | G | prometheus extra server options |
| 136 | pushgateway_enabled | INFRA | PROMETHEUS | bool | G/I | setup pushgateway on this infra node? |
| 137 | pushgateway_options | INFRA | PROMETHEUS | arg | G | pushgateway extra server options |
| 138 | blackbox_enabled | INFRA | PROMETHEUS | bool | G/I | setup blackbox_exporter on this infra node? |
| 139 | blackbox_options | INFRA | PROMETHEUS | arg | G | blackbox_exporter extra server options |
| 140 | alertmanager_enabled | INFRA | PROMETHEUS | bool | G/I | setup alertmanager on this infra node? |
| 141 | alertmanager_options | INFRA | PROMETHEUS | arg | G | alertmanager extra server options |
| 142 | exporter_metrics_path | INFRA | PROMETHEUS | path | G | exporter metric path, /metrics by default |
| 143 | exporter_install | INFRA | PROMETHEUS | enum | G | how to install exporter? none,yum,binary |
| 144 | exporter_repo_url | INFRA | PROMETHEUS | url | G | exporter repo file url if install exporter via yum |
| 145 | grafana_enabled | INFRA | GRAFANA | bool | G/I | enable grafana on this infra node? |
| 146 | grafana_clean | INFRA | GRAFANA | bool | G/A | clean grafana data during init? |
| 147 | grafana_admin_username | INFRA | GRAFANA | username | G | grafana admin username, admin by default |
| 148 | grafana_admin_password | INFRA | GRAFANA | password | G | grafana admin password, pigsty by default |
| 149 | grafana_plugin_cache | INFRA | GRAFANA | path | G | path to grafana plugins cache tarball |
| 150 | grafana_plugin_list | INFRA | GRAFANA | string[] | G | grafana plugins to be downloaded with grafana-cli |
| 151 | loki_enabled | INFRA | LOKI | bool | G/I | enable loki on this infra node? |
| 152 | loki_clean | INFRA | LOKI | bool | G/A | whether remove existing loki data? |
| 153 | loki_data | INFRA | LOKI | path | G | loki data dir, /data/loki by default |
| 154 | loki_retention | INFRA | LOKI | interval | G | loki log retention period, 15d by default |
| 201 | nodename | NODE | NODE_ID | string | I | node instance identity, use hostname if missing, optional |
| 202 | node_cluster | NODE | NODE_ID | string | C | node cluster identity, use ’nodes’ if missing, optional |
| 203 | nodename_overwrite | NODE | NODE_ID | bool | C | overwrite node’s hostname with nodename? |
| 204 | nodename_exchange | NODE | NODE_ID | bool | C | exchange nodename among play hosts? |
| 205 | node_id_from_pg | NODE | NODE_ID | bool | C | use postgres identity as node identity if applicable? |
| 210 | node_default_etc_hosts | NODE | NODE_DNS | string[] | G | static dns records in /etc/hosts |
| 211 | node_etc_hosts | NODE | NODE_DNS | string[] | C | extra static dns records in /etc/hosts |
| 212 | node_dns_method | NODE | NODE_DNS | enum | C | how to handle dns servers: add,none,overwrite |
| 213 | node_dns_servers | NODE | NODE_DNS | string[] | C | dynamic nameserver in /etc/resolv.conf |
| 214 | node_dns_options | NODE | NODE_DNS | string[] | C | dns resolv options in /etc/resolv.conf |
| 220 | node_repo_method | NODE | NODE_PACKAGE | enum | C | how to setup node repo: none,local,public |
| 221 | node_repo_remove | NODE | NODE_PACKAGE | bool | C | remove existing repo on node? |
| 222 | node_repo_local_urls | NODE | NODE_PACKAGE | string[] | C | local repo url, if node_repo_method = local |
| 223 | node_packages | NODE | NODE_PACKAGE | string[] | C | packages to be installed current nodes |
| 224 | node_default_packages | NODE | NODE_PACKAGE | string[] | G | default packages to be installed on all nodes |
| 230 | node_disable_firewall | NODE | NODE_TUNE | bool | C | disable node firewall? true by default |
| 231 | node_disable_selinux | NODE | NODE_TUNE | bool | C | disable node selinux? true by default |
| 232 | node_disable_numa | NODE | NODE_TUNE | bool | C | disable node numa, reboot required |
| 233 | node_disable_swap | NODE | NODE_TUNE | bool | C | disable node swap, use with caution |
| 234 | node_static_network | NODE | NODE_TUNE | bool | C | preserve dns resolver settings after reboot |
| 235 | node_disk_prefetch | NODE | NODE_TUNE | bool | C | setup disk prefetch on HDD to increase performance |
| 236 | node_kernel_modules | NODE | NODE_TUNE | string[] | C | kernel modules to be enabled on this node |
| 237 | node_hugepage_count | NODE | NODE_TUNE | int | C | number of 2MB hugepage, take precedence over ratio |
| 238 | node_hugepage_ratio | NODE | NODE_TUNE | float | C | node mem hugepage ratio, 0 disable it by default |
| 239 | node_overcommit_ratio | NODE | NODE_TUNE | float | C | node mem overcommit ratio, 0 disable it by default |
| 240 | node_tune | NODE | NODE_TUNE | enum | C | node tuned profile: none,oltp,olap,crit,tiny |
| 241 | node_sysctl_params | NODE | NODE_TUNE | dict | C | sysctl parameters in k:v format in addition to tuned |
| 250 | node_data | NODE | NODE_ADMIN | path | C | node main data directory, /data by default |
| 251 | node_admin_enabled | NODE | NODE_ADMIN | bool | C | create a admin user on target node? |
| 252 | node_admin_uid | NODE | NODE_ADMIN | int | C | uid and gid for node admin user |
| 253 | node_admin_username | NODE | NODE_ADMIN | username | C | name of node admin user, dba by default |
| 254 | node_admin_ssh_exchange | NODE | NODE_ADMIN | bool | C | exchange admin ssh key among node cluster |
| 255 | node_admin_pk_current | NODE | NODE_ADMIN | bool | C | add current user’s ssh pk to admin authorized_keys |
| 256 | node_admin_pk_list | NODE | NODE_ADMIN | string[] | C | ssh public keys to be added to admin user |
| 260 | node_timezone | NODE | NODE_TIME | string | C | setup node timezone, empty string to skip |
| 261 | node_ntp_enabled | NODE | NODE_TIME | bool | C | enable chronyd time sync service? |
| 262 | node_ntp_servers | NODE | NODE_TIME | string[] | C | ntp servers in /etc/chrony.conf |
| 263 | node_crontab_overwrite | NODE | NODE_TIME | bool | C | overwrite or append to /etc/crontab? |
| 264 | node_crontab | NODE | NODE_TIME | string[] | C | crontab entries in /etc/crontab |
| 270 | haproxy_enabled | NODE | HAPROXY | bool | C | enable haproxy on this node? |
| 271 | haproxy_clean | NODE | HAPROXY | bool | G/C/A | cleanup all existing haproxy config? |
| 272 | haproxy_reload | NODE | HAPROXY | bool | A | reload haproxy after config? |
| 273 | haproxy_auth_enabled | NODE | HAPROXY | bool | G | enable authentication for haproxy admin page |
| 274 | haproxy_admin_username | NODE | HAPROXY | username | G | haproxy admin username, admin by default |
| 275 | haproxy_admin_password | NODE | HAPROXY | password | G | haproxy admin password, pigsty by default |
| 276 | haproxy_exporter_port | NODE | HAPROXY | port | C | haproxy admin/exporter port, 9101 by default |
| 277 | haproxy_client_timeout | NODE | HAPROXY | interval | C | client side connection timeout, 24h by default |
| 278 | haproxy_server_timeout | NODE | HAPROXY | interval | C | server side connection timeout, 24h by default |
| 279 | haproxy_services | NODE | HAPROXY | service[] | C | list of haproxy service to be exposed on node |
| 280 | node_exporter_enabled | NODE | NODE_EXPORTER | bool | C | setup node_exporter on this node? |
| 281 | node_exporter_port | NODE | NODE_EXPORTER | port | C | node exporter listen port, 9100 by default |
| 282 | node_exporter_options | NODE | NODE_EXPORTER | arg | C | extra server options for node_exporter |
| 283 | promtail_enabled | NODE | PROMTAIL | bool | C | enable promtail logging collector? |
| 284 | promtail_clean | NODE | PROMTAIL | bool | G/A | purge existing promtail status file during init? |
| 285 | promtail_port | NODE | PROMTAIL | port | C | promtail listen port, 9080 by default |
| 286 | promtail_positions | NODE | PROMTAIL | path | C | promtail position status file path |
| 401 | docker_enabled | NODE | DOCKER | bool | C | enable docker on this node? |
| 402 | docker_cgroups_driver | NODE | DOCKER | enum | C | docker cgroup fs driver: cgroupfs,systemd |
| 403 | docker_registry_mirrors | NODE | DOCKER | string[] | C | docker registry mirror list |
| 404 | docker_image_cache | NODE | DOCKER | path | C | docker image cache dir, /tmp/docker by default |
| 501 | etcd_seq | ETCD | ETCD | int | I | etcd instance identifier, REQUIRED |
| 502 | etcd_cluster | ETCD | ETCD | string | C | etcd cluster & group name, etcd by default |
| 503 | etcd_safeguard | ETCD | ETCD | bool | G/C/A | prevent purging running etcd instance? |
| 504 | etcd_clean | ETCD | ETCD | bool | G/C/A | purging existing etcd during initialization? |
| 505 | etcd_data | ETCD | ETCD | path | C | etcd data directory, /data/etcd by default |
| 506 | etcd_port | ETCD | ETCD | port | C | etcd client port, 2379 by default |
| 507 | etcd_peer_port | ETCD | ETCD | port | C | etcd peer port, 2380 by default |
| 508 | etcd_init | ETCD | ETCD | enum | C | etcd initial cluster state, new or existing |
| 509 | etcd_election_timeout | ETCD | ETCD | int | C | etcd election timeout, 1000ms by default |
| 510 | etcd_heartbeat_interval | ETCD | ETCD | int | C | etcd heartbeat interval, 100ms by default |
| 601 | minio_seq | MINIO | MINIO | int | I | minio instance identifier, REQUIRED |
| 602 | minio_cluster | MINIO | MINIO | string | C | minio cluster name, minio by default |
| 603 | minio_clean | MINIO | MINIO | bool | G/C/A | cleanup minio during init?, false by default |
| 604 | minio_user | MINIO | MINIO | username | C | minio os user, minio by default |
| 605 | minio_node | MINIO | MINIO | string | C | minio node name pattern |
| 606 | minio_data | MINIO | MINIO | path | C | minio data dir(s), use {x…y} to specify multi drivers |
| 607 | minio_domain | MINIO | MINIO | string | G | minio service domain name, sss.pigsty by default |
| 608 | minio_port | MINIO | MINIO | port | C | minio service port, 9000 by default |
| 609 | minio_admin_port | MINIO | MINIO | port | C | minio console port, 9001 by default |
| 610 | minio_access_key | MINIO | MINIO | username | C | root access key, minioadmin by default |
| 611 | minio_secret_key | MINIO | MINIO | password | C | root secret key, minioadmin by default |
| 612 | minio_extra_vars | MINIO | MINIO | string | C | extra environment variables for minio server |
| 613 | minio_alias | MINIO | MINIO | string | G | alias name for local minio deployment |
| 614 | minio_buckets | MINIO | MINIO | bucket[] | C | list of minio bucket to be created |
| 615 | minio_users | MINIO | MINIO | user[] | C | list of minio user to be created |
| 701 | redis_cluster | REDIS | REDIS | string | C | redis cluster name, required identity parameter |
| 702 | redis_instances | REDIS | REDIS | dict | I | redis instances definition on this redis node |
| 703 | redis_node | REDIS | REDIS | int | I | redis node sequence number, node int id required |
| 710 | redis_fs_main | REDIS | REDIS | path | C | redis main data mountpoint, /data by default |
| 711 | redis_exporter_enabled | REDIS | REDIS | bool | C | install redis exporter on redis nodes? |
| 712 | redis_exporter_port | REDIS | REDIS | port | C | redis exporter listen port, 9121 by default |
| 713 | redis_exporter_options | REDIS | REDIS | string | C/I | cli args and extra options for redis exporter |
| 720 | redis_safeguard | REDIS | REDIS | bool | C | prevent purging running redis instance? |
| 721 | redis_clean | REDIS | REDIS | bool | C | purging existing redis during init? |
| 722 | redis_rmdata | REDIS | REDIS | bool | A | remove redis data when purging redis server? |
| 723 | redis_mode | REDIS | REDIS | enum | C | redis mode: standalone,cluster,sentinel |
| 724 | redis_conf | REDIS | REDIS | string | C | redis config template path, except sentinel |
| 725 | redis_bind_address | REDIS | REDIS | ip | C | redis bind address, empty string will use host ip |
| 726 | redis_max_memory | REDIS | REDIS | size | C/I | max memory used by each redis instance |
| 727 | redis_mem_policy | REDIS | REDIS | enum | C | redis memory eviction policy |
| 728 | redis_password | REDIS | REDIS | password | C | redis password, empty string will disable password |
| 729 | redis_rdb_save | REDIS | REDIS | string[] | C | redis rdb save directives, disable with empty list |
| 730 | redis_aof_enabled | REDIS | REDIS | bool | C | enable redis append only file? |
| 731 | redis_rename_commands | REDIS | REDIS | dict | C | rename redis dangerous commands |
| 732 | redis_cluster_replicas | REDIS | REDIS | int | C | replica number for one master in redis cluster |
| 801 | pg_mode | PGSQL | PG_ID | enum | C | pgsql cluster mode: pgsql,citus,gpsql |
| 802 | pg_cluster | PGSQL | PG_ID | string | C | pgsql cluster name, REQUIRED identity parameter |
| 803 | pg_seq | PGSQL | PG_ID | int | I | pgsql instance seq number, REQUIRED identity parameter |
| 804 | pg_role | PGSQL | PG_ID | enum | I | pgsql role, REQUIRED, could be primary,replica,offline |
| 805 | pg_instances | PGSQL | PG_ID | dict | I | define multiple pg instances on node in {port:ins_vars} format |
| 806 | pg_upstream | PGSQL | PG_ID | ip | I | repl upstream ip addr for standby cluster or cascade replica |
| 807 | pg_shard | PGSQL | PG_ID | string | C | pgsql shard name, optional identity for sharding clusters |
| 808 | pg_group | PGSQL | PG_ID | int | C | pgsql shard index number, optional identity for sharding clusters |
| 809 | gp_role | PGSQL | PG_ID | enum | C | greenplum role of this cluster, could be master or segment |
| 810 | pg_exporters | PGSQL | PG_ID | dict | C | additional pg_exporters to monitor remote postgres instances |
| 811 | pg_offline_query | PGSQL | PG_ID | bool | I | set to true to enable offline query on this instance |
| 820 | pg_users | PGSQL | PG_BUSINESS | user[] | C | postgres business users |
| 821 | pg_databases | PGSQL | PG_BUSINESS | database[] | C | postgres business databases |
| 822 | pg_services | PGSQL | PG_BUSINESS | service[] | C | postgres business services |
| 823 | pg_hba_rules | PGSQL | PG_BUSINESS | hba[] | C | business hba rules for postgres |
| 824 | pgb_hba_rules | PGSQL | PG_BUSINESS | hba[] | C | business hba rules for pgbouncer |
| 831 | pg_replication_username | PGSQL | PG_BUSINESS | username | G | postgres replication username, replicator by default |
| 832 | pg_replication_password | PGSQL | PG_BUSINESS | password | G | postgres replication password, DBUser.Replicator by default |
| 833 | pg_admin_username | PGSQL | PG_BUSINESS | username | G | postgres admin username, dbuser_dba by default |
| 834 | pg_admin_password | PGSQL | PG_BUSINESS | password | G | postgres admin password in plain text, DBUser.DBA by default |
| 835 | pg_monitor_username | PGSQL | PG_BUSINESS | username | G | postgres monitor username, dbuser_monitor by default |
| 836 | pg_monitor_password | PGSQL | PG_BUSINESS | password | G | postgres monitor password, DBUser.Monitor by default |
| 837 | pg_dbsu_password | PGSQL | PG_BUSINESS | password | G/C | postgres dbsu password, empty string disable it by default |
| 840 | pg_dbsu | PGSQL | PG_INSTALL | username | C | os dbsu name, postgres by default, better not change it |
| 841 | pg_dbsu_uid | PGSQL | PG_INSTALL | int | C | os dbsu uid and gid, 26 for default postgres users and groups |
| 842 | pg_dbsu_sudo | PGSQL | PG_INSTALL | enum | C | dbsu sudo privilege, none,limit,all,nopass. limit by default |
| 843 | pg_dbsu_home | PGSQL | PG_INSTALL | path | C | postgresql home directory, /var/lib/pgsql by default |
| 844 | pg_dbsu_ssh_exchange | PGSQL | PG_INSTALL | bool | C | exchange postgres dbsu ssh key among same pgsql cluster |
| 845 | pg_version | PGSQL | PG_INSTALL | enum | C | postgres major version to be installed, 15 by default |
| 846 | pg_bin_dir | PGSQL | PG_INSTALL | path | C | postgres binary dir, /usr/pgsql/bin by default |
| 847 | pg_log_dir | PGSQL | PG_INSTALL | path | C | postgres log dir, /pg/log/postgres by default |
| 848 | pg_packages | PGSQL | PG_INSTALL | string[] | C | pg packages to be installed, ${pg_version} will be replaced |
| 849 | pg_extensions | PGSQL | PG_INSTALL | string[] | C | pg extensions to be installed, ${pg_version} will be replaced |
| 850 | pg_safeguard | PGSQL | PG_BOOTSTRAP | bool | G/C/A | prevent purging running postgres instance? false by default |
| 851 | pg_clean | PGSQL | PG_BOOTSTRAP | bool | G/C/A | purging existing postgres during pgsql init? true by default |
| 852 | pg_data | PGSQL | PG_BOOTSTRAP | path | C | postgres data directory, /pg/data by default |
| 853 | pg_fs_main | PGSQL | PG_BOOTSTRAP | path | C | mountpoint/path for postgres main data, /data by default |
| 854 | pg_fs_bkup | PGSQL | PG_BOOTSTRAP | path | C | mountpoint/path for pg backup data, /data/backup by default |
| 855 | pg_storage_type | PGSQL | PG_BOOTSTRAP | enum | C | storage type for pg main data, SSD,HDD, SSD by default |
| 856 | pg_dummy_filesize | PGSQL | PG_BOOTSTRAP | size | C | size of /pg/dummy, hold 64MB disk space for emergency use |
| 857 | pg_listen | PGSQL | PG_BOOTSTRAP | ip | C | postgres listen address, 0.0.0.0 (all ipv4 addr) by default |
| 858 | pg_port | PGSQL | PG_BOOTSTRAP | port | C | postgres listen port, 5432 by default |
| 859 | pg_localhost | PGSQL | PG_BOOTSTRAP | path | C | postgres unix socket dir for localhost connection |
| 860 | pg_namespace | PGSQL | PG_BOOTSTRAP | path | C | top level key namespace in etcd, used by patroni & vip |
| 861 | patroni_enabled | PGSQL | PG_BOOTSTRAP | bool | C | if disabled, no postgres cluster will be created during init |
| 862 | patroni_mode | PGSQL | PG_BOOTSTRAP | enum | C | patroni working mode: default,pause,remove |
| 863 | patroni_port | PGSQL | PG_BOOTSTRAP | port | C | patroni listen port, 8008 by default |
| 864 | patroni_log_dir | PGSQL | PG_BOOTSTRAP | path | C | patroni log dir, /pg/log/patroni by default |
| 865 | patroni_ssl_enabled | PGSQL | PG_BOOTSTRAP | bool | G | secure patroni RestAPI communications with SSL? |
| 866 | patroni_watchdog_mode | PGSQL | PG_BOOTSTRAP | enum | C | patroni watchdog mode: automatic,required,off. off by default |
| 867 | patroni_username | PGSQL | PG_BOOTSTRAP | username | C | patroni restapi username, postgres by default |
| 868 | patroni_password | PGSQL | PG_BOOTSTRAP | password | C | patroni restapi password, Patroni.API by default |
| 869 | patroni_citus_db | PGSQL | PG_BOOTSTRAP | string | C | citus database managed by patroni, postgres by default |
| 870 | pg_conf | PGSQL | PG_BOOTSTRAP | enum | C | config template: oltp,olap,crit,tiny. oltp.yml by default |
| 871 | pg_max_conn | PGSQL | PG_BOOTSTRAP | int | C | postgres max connections, auto will use recommended value |
| 872 | pg_shared_buffer_ratio | PGSQL | PG_BOOTSTRAP | float | C | postgres shared buffer memory ratio, 0.25 by default, 0.1~0.4 |
| 873 | pg_rto | PGSQL | PG_BOOTSTRAP | int | C | recovery time objective in seconds, 30s by default |
| 874 | pg_rpo | PGSQL | PG_BOOTSTRAP | int | C | recovery point objective in bytes, 1MiB at most by default |
| 875 | pg_libs | PGSQL | PG_BOOTSTRAP | string | C | preloaded libraries, pg_stat_statements,auto_explain by default |
| 876 | pg_delay | PGSQL | PG_BOOTSTRAP | interval | I | replication apply delay for standby cluster leader |
| 877 | pg_checksum | PGSQL | PG_BOOTSTRAP | bool | C | enable data checksum for postgres cluster? |
| 878 | pg_pwd_enc | PGSQL | PG_BOOTSTRAP | enum | C | passwords encryption algorithm: md5,scram-sha-256 |
| 879 | pg_encoding | PGSQL | PG_BOOTSTRAP | enum | C | database cluster encoding, UTF8 by default |
| 880 | pg_locale | PGSQL | PG_BOOTSTRAP | enum | C | database cluster local, C by default |
| 881 | pg_lc_collate | PGSQL | PG_BOOTSTRAP | enum | C | database cluster collate, C by default |
| 882 | pg_lc_ctype | PGSQL | PG_BOOTSTRAP | enum | C | database character type, en_US.UTF8 by default |
| 890 | pgbouncer_enabled | PGSQL | PG_BOOTSTRAP | bool | C | if disabled, pgbouncer will not be launched on pgsql host |
| 891 | pgbouncer_port | PGSQL | PG_BOOTSTRAP | port | C | pgbouncer listen port, 6432 by default |
| 892 | pgbouncer_log_dir | PGSQL | PG_BOOTSTRAP | path | C | pgbouncer log dir, /pg/log/pgbouncer by default |
| 893 | pgbouncer_auth_query | PGSQL | PG_BOOTSTRAP | bool | C | query postgres to retrieve unlisted business users? |
| 894 | pgbouncer_poolmode | PGSQL | PG_BOOTSTRAP | enum | C | pooling mode: transaction,session,statement, transaction by default |
| 895 | pgbouncer_sslmode | PGSQL | PG_BOOTSTRAP | enum | C | pgbouncer client ssl mode, disable by default |
| 900 | pg_provision | PGSQL | PG_PROVISION | bool | C | provision postgres cluster after bootstrap |
| 901 | pg_init | PGSQL | PG_PROVISION | string | G/C | provision init script for cluster template, pg-init by default |
| 902 | pg_default_roles | PGSQL | PG_PROVISION | role[] | G/C | default roles and users in postgres cluster |
| 903 | pg_default_privileges | PGSQL | PG_PROVISION | string[] | G/C | default privileges when created by admin user |
| 904 | pg_default_schemas | PGSQL | PG_PROVISION | string[] | G/C | default schemas to be created |
| 905 | pg_default_extensions | PGSQL | PG_PROVISION | extension[] | G/C | default extensions to be created |
| 906 | pg_reload | PGSQL | PG_PROVISION | bool | A | reload postgres after hba changes |
| 907 | pg_default_hba_rules | PGSQL | PG_PROVISION | hba[] | G/C | postgres default host-based authentication rules |
| 908 | pgb_default_hba_rules | PGSQL | PG_PROVISION | hba[] | G/C | pgbouncer default host-based authentication rules |
| 910 | pgbackrest_enabled | PGSQL | PG_BACKUP | bool | C | enable pgbackrest on pgsql host? |
| 911 | pgbackrest_clean | PGSQL | PG_BACKUP | bool | C | remove pg backup data during init? |
| 912 | pgbackrest_log_dir | PGSQL | PG_BACKUP | path | C | pgbackrest log dir, /pg/log/pgbackrest by default |
| 913 | pgbackrest_method | PGSQL | PG_BACKUP | enum | C | pgbackrest repo method: local,minio,etc… |
| 914 | pgbackrest_repo | PGSQL | PG_BACKUP | dict | G/C | pgbackrest repo: <https://pgbackrest.org/configuration.html#section-repository> |
| 921 | pg_weight | PGSQL | PG_SERVICE | int | I | relative load balance weight in service, 100 by default, 0-255 |
| 922 | pg_service_provider | PGSQL | PG_SERVICE | string | G/C | dedicate haproxy node group name, or empty string for local nodes by default |
| 923 | pg_default_service_dest | PGSQL | PG_SERVICE | enum | G/C | default service destination if svc.dest=‘default’ |
| 924 | pg_default_services | PGSQL | PG_SERVICE | service[] | G/C | postgres default service definitions |
| 931 | pg_vip_enabled | PGSQL | PG_SERVICE | bool | C | enable a l2 vip for pgsql primary? false by default |
| 932 | pg_vip_address | PGSQL | PG_SERVICE | cidr4 | C | vip address in <ipv4>/<mask> format, require if vip is enabled |
| 933 | pg_vip_interface | PGSQL | PG_SERVICE | string | C/I | vip network interface to listen, eth0 by default |
| 934 | pg_dns_suffix | PGSQL | PG_SERVICE | string | C | pgsql dns suffix, ’’ by default |
| 935 | pg_dns_target | PGSQL | PG_SERVICE | enum | C | auto, primary, vip, none, or ad hoc ip |
| 940 | pg_exporter_enabled | PGSQL | PG_EXPORTER | bool | C | enable pg_exporter on pgsql hosts? |
| 941 | pg_exporter_config | PGSQL | PG_EXPORTER | string | C | pg_exporter configuration file name |
| 942 | pg_exporter_cache_ttls | PGSQL | PG_EXPORTER | string | C | pg_exporter collector ttl stage in seconds, ‘1,10,60,300’ by default |
| 943 | pg_exporter_port | PGSQL | PG_EXPORTER | port | C | pg_exporter listen port, 9630 by default |
| 944 | pg_exporter_params | PGSQL | PG_EXPORTER | string | C | extra url parameters for pg_exporter dsn |
| 945 | pg_exporter_url | PGSQL | PG_EXPORTER | pgurl | C | overwrite auto-generate pg dsn if specified |
| 946 | pg_exporter_auto_discovery | PGSQL | PG_EXPORTER | bool | C | enable auto database discovery? enabled by default |
| 947 | pg_exporter_exclude_database | PGSQL | PG_EXPORTER | string | C | csv of database that WILL NOT be monitored during auto-discovery |
| 948 | pg_exporter_include_database | PGSQL | PG_EXPORTER | string | C | csv of database that WILL BE monitored during auto-discovery |
| 949 | pg_exporter_connect_timeout | PGSQL | PG_EXPORTER | int | C | pg_exporter connect timeout in ms, 200 by default |
| 950 | pg_exporter_options | PGSQL | PG_EXPORTER | arg | C | overwrite extra options for pg_exporter |
| 951 | pgbouncer_exporter_enabled | PGSQL | PG_EXPORTER | bool | C | enable pgbouncer_exporter on pgsql hosts? |
| 952 | pgbouncer_exporter_port | PGSQL | PG_EXPORTER | port | C | pgbouncer_exporter listen port, 9631 by default |
| 953 | pgbouncer_exporter_url | PGSQL | PG_EXPORTER | pgurl | C | overwrite auto-generate pgbouncer dsn if specified |
| 954 | pgbouncer_exporter_options | PGSQL | PG_EXPORTER | arg | C | overwrite extra options for pgbouncer_exporter |
INFRA
Parameters about pigsty infrastructure components: local yum repo, nginx, dnsmasq, prometheus, grafana, loki, alertmanager, pushgateway, blackbox_exporter, etc…
META
This section contains some metadata of current pigsty deployments, such as version string, admin node IP address, repo mirror region and http(s) proxy when downloading pacakges.
1. version: v2.0.2 # pigsty version string
2. admin_ip: 10.10.10.10 # admin node ip address
3. region: default # upstream mirror region: default,china,europe
4. proxy_env: # global proxy env when downloading packages
5. no_proxy: "localhost,127.0.0.1,10.0.0.0/8,192.168.0.0/16,*.pigsty,*.aliyun.com,mirrors.*,*.myqcloud.com,*.tsinghua.edu.cn"
6. # http_proxy: # set your proxy here: e.g http://user:pass@proxy.xxx.com
7. # https_proxy: # set your proxy here: e.g http://user:pass@proxy.xxx.com
8. # all_proxy: # set your proxy here: e.g http://user:pass@proxy.xxx.com
version
name: version, type: string, level: G
pigsty version string
default value:v2.0.2
It will be used for pigsty introspection & content rendering.
admin_ip
name: admin_ip, type: ip, level: G
admin node ip address
default value:10.10.10.10
Node with this ip address will be treated as admin node, usually point to the first node that install Pigsty.
The default value 10.10.10.10 is a placeholder which will be replaced during configure
This parameter is referenced by many other parameters, such as:
The exact string ${admin_ip} will be replaced with the actual admin_ip for above parameters.
region
name: region, type: enum, level: G
upstream mirror region: default,china,europe
default value: default
If a region other than default is set, and there’s a corresponding entry in repo_upstream.[repo].baseurl, it will be used instead of default.
For example, if china is used, pigsty will use China mirrors designated in repo_upstream if applicable.
proxy_env
name: proxy_env, type: dict, level: G
global proxy env when downloading packages
default value:
1. proxy_env: # global proxy env when downloading packages
2. http_proxy: 'http://username:password@proxy.address.com'
3. https_proxy: 'http://username:password@proxy.address.com'
4. all_proxy: 'http://username:password@proxy.address.com'
5. no_proxy: "localhost,127.0.0.1,10.0.0.0/8,192.168.0.0/16,*.pigsty,*.aliyun.com,mirrors.aliyuncs.com,mirrors.tuna.tsinghua.edu.cn,mirrors.zju.edu.cn"
It’s quite important to use http proxy in restricted production environment, or your Internet access is blocked (e.g. Mainland China)
CA
Self-Signed CA used by pigsty. It is required to support advanced security features.
1. ca_method: create # create,recreate,copy, create by default
2. ca_cn: pigsty-ca # ca common name, fixed as pigsty-ca
3. cert_validity: 7300d # cert validity, 20 years by default
ca_method
name: ca_method, type: enum, level: G
available options: create,recreate,copy
default value: create
create: Create a new CA public-private key pair if not exists, use if existsrecreate: Always re-create a new CA public-private key paircopy: Copy the existing CA public and private keys from localfiles/pki/ca, abort if missing
If you already have a pair of ca.crt and ca.key, put them under files/pki/ca and set ca_method to copy.
ca_cn
name: ca_cn, type: string, level: G
ca common name, not recommending to change it.
default value: pigsty-ca
you can check that with openssl x509 -text -in /etc/pki/ca.crt
cert_validity
name: cert_validity, type: interval, level: G
cert validity, 20 years by default, which is enough for most scenarios
default value: 7300d
INFRA_ID
Infrastructure identity and portal definition.
``` 1. #infra_seq: 1 # infra node identity, explicitly required 2. infra_portal: # infra services exposed via portal 3. home : { domain: h.pigsty } 4. grafana : { domain: g.pigsty ,endpoint: "${admin_ip}:3000" ,websocket: true } 5. prometheus : { domain: p.pigsty ,endpoint: "${admin_ip}:9090" } 6. alertmanager : { domain: a.pigsty ,endpo
(本文超出站点单文档体积上限,已截断)
