Pigsty Install Procedure

Install procedure of pigsty installation on full 4 nodes sandbox

prepare

请参考 拉起沙箱环境过程记录 拉起本地4节点虚拟机沙箱，当然您也可以用其他办法创建几台虚拟机，或直接使用现有的物理机乃至云虚拟机进行部署。

登录管理节点，并确保可以ssh sudo其他节点：

  1. $ ssh meta
  2. [vagrant@meta ~]$ ssh 10.10.10.10 sudo hostname -a
  3. Warning: Permanently added '10.10.10.10' (ECDSA) to the list of known hosts.
  4. meta
  5. [vagrant@meta ~]$ ssh 10.10.10.11 sudo hostname -a
  6. Warning: Permanently added '10.10.10.11' (ECDSA) to the list of known hosts.
  7. node-1
  8. [vagrant@meta ~]$ ssh 10.10.10.12 sudo hostname -a
  9. Warning: Permanently added '10.10.10.12' (ECDSA) to the list of known hosts.
  10. node-2
  11. [vagrant@meta ~]$ ssh 10.10.10.13 sudo hostname -a
  12. Warning: Permanently added '10.10.10.13' (ECDSA) to the list of known hosts.
  13. node-3

download

下载最新的Pigsty源码包至本地，大小约1MB。

  1. [vagrant@meta ~]$ bash -c "$(curl -fsSL http://download.pigsty.cc/get)"
  2. [INFO] download pigsty.tgz from http://download.pigsty.cc/v1.5.1/pigsty.tgz
  3.   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
  4.                                  Dload  Upload   Total   Spent    Left  Speed
  5. 100  897k  100  897k    0     0  1195k      0 --:--:-- --:--:-- --:--:-- 1195k
  6. [INFO] extract /tmp/pigsty.tgz to /home/vagrant/pigsty
  7. [HINT] proceed with cd ~/pigsty; ./configure; ./infra.yml;

使用源码包中自带的download脚本，下载离线软件包（可选）

  1. [vagrant@meta ~]$ cd ./pigsty
  2. [vagrant@meta pigsty]$ ./download pkg
  3. [ OK ] download from CDN http://download.pigsty.cc/v1.5.1/pkg.tgz to /tmp/pkg.tgz
  4.   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
  5.                                  Dload  Upload   Total   Spent    Left  Speed
  6. 100 1075M  100 1075M    0     0  10.6M      0  0:01:40  0:01:40 --:--:-- 10.0M
  7. [ OK ] repo = extract from /tmp/pkg.tgz
  8. [ OK ] repo file = /etc/yum.repos.d/pigsty-local.repo

configure

使用标准的 demo 模板进行 配置过程

  1. [vagrant@meta pigsty]$ ./configure -m demo
  2. [ OK ] cache = download from internet
  3. configure pigsty v1.5.1 begin
  4. [ OK ] kernel = Linux
  5. [ OK ] machine = x86_64
  6. [ OK ] release = 7.8.2003 , perfect
  7. [ OK ] sudo = vagrant ok
  8. [ OK ] ssh = vagrant@127.0.0.1 ok
  9. [WARN] Multiple IP address candidates found:
  10.     (1) 10.0.2.15        inet 10.0.2.15/24 brd 10.0.2.255 scope global noprefixroute dynamic eth0
  11.     (2) 10.10.10.10        inet 10.10.10.10/24 brd 10.10.10.255 scope global noprefixroute eth1
  12. [ OK ] primary_ip = 10.10.10.10 (from demo)
  13. [ OK ] admin = vagrant@10.10.10.10 ok
  14. [ OK ] mode = demo (manually set)
  15. [ OK ] spec = mini (cpu = 2)
  16. [ OK ] config = demo @ 10.10.10.10
  17. [ OK ] cache = /tmp/pkg.tgz exists
  18. [ OK ] repo = /www/pigsty ok
  19. [ OK ] repo file = /etc/yum.repos.d/pigsty-local.repo
  20. [ OK ] utils = install from local file repo
  21. [ OK ] ansible = ansible 2.9.27
  22. configure pigsty done. Use 'make install' to proceed

install

使用 make install 在本机上完成安装，这实际上是执行了 infra.yml 剧本

make install

  1. [vagrant@meta pigsty]$ make install
  2. ./infra.yml
  4. PLAY [Node Identity] *********************************************************************************
  6. TASK [Overwrite node_cluster] ************************************************************************
  7. ok: [10.10.10.10]
  9. TASK [Overwrite nodename] ****************************************************************************
  10. ok: [10.10.10.10]
  12. TASK [debug] *****************************************************************************************
  13. ok: [10.10.10.10] => {
  14.     "msg": "ins=pg-meta-1 cls=pg-meta"
  15. }
  17. PLAY [Infra Bootstrap] *******************************************************************************
  19. TASK [environ : Create pigsty resource dirs on /etc/pigsty] ******************************************
  20. changed: [10.10.10.10] => (item=/etc/pigsty)
  21. changed: [10.10.10.10] => (item=/etc/pigsty/playbooks)
  22. changed: [10.10.10.10] => (item=/etc/pigsty/dashboards)
  23. changed: [10.10.10.10] => (item=/etc/pigsty/datasources)
  25. TASK [environ : Create patronictl resource] **********************************************************
  26. changed: [10.10.10.10]
  28. TASK [environ : Get current username] ****************************************************************
  29. ok: [10.10.10.10]
  31. TASK [environ : Create admin user ssh key pair if not exists] ****************************************
  32. ok: [10.10.10.10]
  34. TASK [environ : Write default user credential to pgpass] *********************************************
  35. changed: [10.10.10.10] => (item=*:*:*:replicator:DBUser.Replicator)
  36. changed: [10.10.10.10] => (item=*:*:*:dbuser_monitor:DBUser.Monitor)
  37. changed: [10.10.10.10] => (item=*:*:*:dbuser_dba:DBUser.DBA)
  39. TASK [environ : Write default meta service to pg_service] ********************************************
  40. changed: [10.10.10.10]
  42. TASK [environ : Write servers.json to home dir] ******************************************************
  43. changed: [10.10.10.10]
  45. TASK [Set environment for admin user] ****************************************************************
  46. changed: [10.10.10.10]
  48. TASK [Enable environment for admin user] *************************************************************
  49. changed: [10.10.10.10]
  51. TASK [Create local repo directory] *******************************************************************
  52. ok: [10.10.10.10]
  54. TASK [Backup & remove existing repos] ****************************************************************
  55. changed: [10.10.10.10]
  57. TASK [Add required upstream repos] *******************************************************************
  58. [WARNING]: Using a variable for a task's 'args' is unsafe in some situations (see
  59. https://docs.ansible.com/ansible/devel/reference_appendices/faq.html#argsplat-unsafe)
  60. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Base', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/os/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/os/$basearch/', u'http://mirror.centos.org/centos/$releasever/os/$basearch/'], u'name': u'base'})
  61. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Updates', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/updates/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/updates/$basearch/', u'http://mirror.centos.org/centos/$releasever/updates/$basearch/'], u'name': u'updates'})
  62. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Extras', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/extras/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/extras/$basearch/', u'http://mirror.centos.org/centos/$releasever/extras/$basearch/'], u'name': u'extras'})
  63. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS $releasever - epel', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/epel/$releasever/$basearch', u'http://mirrors.aliyun.com/epel/$releasever/$basearch', u'http://download.fedoraproject.org/pub/epel/$releasever/$basearch'], u'name': u'epel'})
  64. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'enabled': True, u'description': u'Grafana', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/grafana/yum/rpm', u'https://packages.grafana.com/oss/rpm'], u'name': u'grafana'})
  65. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'Prometheus and exporters', u'baseurl': u'https://packagecloud.io/prometheus-rpm/release/el/$releasever/$basearch', u'name': u'prometheus'})
  66. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'PostgreSQL common RPMs for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'http://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/common/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg-common'})
  67. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'PostgreSQL 14 for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/14/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg14'})
  68. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'TimescaleDB for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://packagecloud.io/timescale/timescaledb/el/7/$basearch'], u'name': u'timescaledb'})
  69. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/sclo/', u'name': u'centos-sclo'})
  70. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo rh', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/rh/', u'name': u'centos-sclo-rh'})
  71. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'nginx', u'baseurl': u'http://nginx.org/packages/centos/$releasever/$basearch/', u'description': u'Nginx Official Yum Repo'})
  72. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'harbottle', u'baseurl': u'https://download.copr.fedorainfracloud.org/results/harbottle/main/epel-$releasever-$basearch/', u'description': u'Copr repo for main owned by harbottle'})
  73. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'pg_probackup', u'baseurl': u'https://repo.postgrespro.ru/pg_probackup-forks/rpm/latest/centos-$releasever-$basearch', u'description': u'PG_PROBACKUP Centos packages for PostgresPro Standard and Enterprise - $basearch'})
  74. changed: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'docker-ce', u'baseurl': [u'https://mirrors.aliyun.com/docker-ce/linux/centos/$releasever/$basearch/stable', u'https://download.docker.com/linux/centos/$releasever/$basearch/stable'], u'description': u'Docker CE Stable - $basearch'})
  76. TASK [Check repo pkgs cache exists] ******************************************************************
  77. ok: [10.10.10.10]
  79. TASK [Set fact whether repo_exists] ******************************************************************
  80. ok: [10.10.10.10]
  82. TASK [Move upstream repo to backup] ******************************************************************
  83. changed: [10.10.10.10]
  85. TASK [Add local file system repos] *******************************************************************
  86. changed: [10.10.10.10]
  88. TASK [repo : Remake yum cache if not exists] *********************************************************
  89. changed: [10.10.10.10]
  91. TASK [Install repo bootstrap packages] ***************************************************************
  92. changed: [10.10.10.10]
  94. TASK [Render repo nginx server files] ****************************************************************
  95. changed: [10.10.10.10] => (item={u'dest': u'/etc/nginx/nginx.conf', u'src': u'nginx.conf.j2'})
  96. changed: [10.10.10.10] => (item={u'dest': u'/etc/nginx/conf.d/default.conf', u'src': u'default.conf.j2'})
  97. changed: [10.10.10.10] => (item={u'dest': u'/www/index.html', u'src': u'index.html.j2'})
  98. changed: [10.10.10.10] => (item={u'dest': u'/www/pigsty.repo', u'src': u'local.repo.j2'})
  100. TASK [Disable selinux for repo server] ***************************************************************
  101. [WARNING]: SELinux state temporarily changed from 'enforcing' to 'permissive'. State change will take
  102. effect next reboot.
  103. changed: [10.10.10.10]
  105. TASK [Launch repo nginx server] **********************************************************************
  106. changed: [10.10.10.10]
  108. TASK [Waits repo server online] **********************************************************************
  109. ok: [10.10.10.10]
  111. TASK [Download repo packages] ************************************************************************
  112. skipping: [10.10.10.10] => (item=epel-release nginx wget yum-utils yum createrepo sshpass zip unzip)
  113. skipping: [10.10.10.10] => (item=ntp chrony uuid lz4 bzip2 nc pv jq vim-enhanced make patch bash lsof wget git tuned perf ftp lrzsz rsync)
  114. skipping: [10.10.10.10] => (item=numactl grubby sysstat dstat iotop bind-utils net-tools tcpdump socat ipvsadm telnet ca-certificates keepalived)
  115. skipping: [10.10.10.10] => (item=readline zlib openssl openssh-clients libyaml libxml2 libxslt libevent perl perl-devel perl-ExtUtils*)
  116. skipping: [10.10.10.10] => (item=readline-devel zlib-devel uuid-devel libuuid-devel libxml2-devel libxslt-devel openssl-devel libicu-devel)
  117. skipping: [10.10.10.10] => (item=grafana prometheus2 pushgateway alertmanager mtail consul consul_exporter consul-template etcd dnsmasq)
  118. skipping: [10.10.10.10] => (item=node_exporter nginx_exporter blackbox_exporter redis_exporter)
  119. skipping: [10.10.10.10] => (item=ansible python python-pip python-psycopg2)
  120. skipping: [10.10.10.10] => (item=python3 python3-psycopg2 python36-requests python3-etcd python3-consul python36-urllib3 python36-idna python36-pyOpenSSL python36-cryptography)
  121. skipping: [10.10.10.10] => (item=patroni patroni-consul patroni-etcd pgbouncer pg_cli pgbadger pg_activity tail_n_mail)
  122. skipping: [10.10.10.10] => (item=pgcenter boxinfo check_postgres emaj pgbconsole pg_bloat_check pgquarrel barman barman-cli pgloader pgFormatter pitrery pspg pgxnclient PyGreSQL)
  123. skipping: [10.10.10.10] => (item=postgresql14* postgis32_14* citus_14* pglogical_14* timescaledb-2-postgresql-14 pg_repack_14 wal2json_14)
  124. skipping: [10.10.10.10] => (item=pg_qualstats_14 pg_stat_kcache_14 pg_stat_monitor_14 pg_top_14 pg_track_settings_14 pg_wait_sampling_14 pg_probackup-std-14)
  125. skipping: [10.10.10.10] => (item=pg_statement_rollback_14 system_stats_14 plproxy_14 plsh_14 pldebugger_14 plpgsql_check_14 pgmemcache_14)
  126. skipping: [10.10.10.10] => (item=mysql_fdw_14 ogr_fdw_14 tds_fdw_14 sqlite_fdw_14 firebird_fdw_14 hdfs_fdw_14 mongo_fdw_14 osm_fdw_14 pgbouncer_fdw_14)
  127. skipping: [10.10.10.10] => (item=hypopg_14 geoip_14 rum_14 hll_14 ip4r_14 prefix_14 pguri_14 tdigest_14 topn_14 periods_14)
  128. skipping: [10.10.10.10] => (item=bgw_replstatus_14 count_distinct_14 credcheck_14 ddlx_14 extra_window_functions_14 logerrors_14 mysqlcompat_14 orafce_14)
  129. skipping: [10.10.10.10] => (item=repmgr_14 pg_auth_mon_14 pg_auto_failover_14 pg_background_14 pg_bulkload_14 pg_catcheck_14 pg_comparator_14)
  130. skipping: [10.10.10.10] => (item=pg_cron_14 pg_fkpart_14 pg_jobmon_14 pg_partman_14 pg_permissions_14 pg_prioritize_14 pgagent_14)
  131. skipping: [10.10.10.10] => (item=pgaudit16_14 pgauditlogtofile_14 pgcryptokey_14 pgexportdoc_14 pgfincore_14 pgimportdoc_14 powa_14 pgmp_14 pgq_14)
  132. skipping: [10.10.10.10] => (item=pgquarrel-0.7.0-1 pgsql_tweaks_14 pgtap_14 pgtt_14 postgresql-unit_14 postgresql_anonymizer_14 postgresql_faker_14)
  133. skipping: [10.10.10.10] => (item=safeupdate_14 semver_14 set_user_14 sslutils_14 table_version_14)
  134. skipping: [10.10.10.10] => (item=clang coreutils diffutils rpm-build rpm-devel rpmlint rpmdevtools bison flex)
  135. skipping: [10.10.10.10] => (item=docker-ce docker-compose kubelet kubectl kubeadm kubernetes-cni helm)
  137. TASK [repo : Download web url packages] **************************************************************
  138. skipping: [10.10.10.10] => (item=https://github.com/Vonng/loki-rpm/releases/download/v2.5.0/loki-2.5.0.x86_64.rpm)
  139. skipping: [10.10.10.10] => (item=https://github.com/Vonng/loki-rpm/releases/download/v2.5.0/promtail-2.5.0.x86_64.rpm)
  140. skipping: [10.10.10.10] => (item=https://github.com/Vonng/pg_exporter/releases/download/v0.5.0/pg_exporter-0.5.0.x86_64.rpm)
  141. skipping: [10.10.10.10] => (item=https://github.com/cybertec-postgresql/vip-manager/releases/download/v1.0.2/vip-manager-1.0.2-1.x86_64.rpm)
  142. skipping: [10.10.10.10] => (item=https://github.com/Vonng/haproxy-rpm/releases/download/v2.5.7/haproxy-2.5.7-1.el7.x86_64.rpm)
  143. skipping: [10.10.10.10] => (item=https://github.com/Vonng/pigsty-pkg/releases/download/misc/redis-6.2.7-1.el7.remi.x86_64.rpm)
  144. skipping: [10.10.10.10] => (item=https://github.com/dalibo/pev2/releases/download/v0.24.0/pev2.tar.gz)
  145. skipping: [10.10.10.10] => (item=https://github.com/Vonng/pigsty-pkg/releases/download/misc/polysh-0.4-1.noarch.rpm)
  147. TASK [Download repo pkg dependencies] ****************************************************************
  148. skipping: [10.10.10.10] => (item=epel-release nginx wget yum-utils yum createrepo sshpass zip unzip)
  149. skipping: [10.10.10.10] => (item=ntp chrony uuid lz4 bzip2 nc pv jq vim-enhanced make patch bash lsof wget git tuned perf ftp lrzsz rsync)
  150. skipping: [10.10.10.10] => (item=numactl grubby sysstat dstat iotop bind-utils net-tools tcpdump socat ipvsadm telnet ca-certificates keepalived)
  151. skipping: [10.10.10.10] => (item=readline zlib openssl openssh-clients libyaml libxml2 libxslt libevent perl perl-devel perl-ExtUtils*)
  152. skipping: [10.10.10.10] => (item=readline-devel zlib-devel uuid-devel libuuid-devel libxml2-devel libxslt-devel openssl-devel libicu-devel)
  153. skipping: [10.10.10.10] => (item=grafana prometheus2 pushgateway alertmanager mtail consul consul_exporter consul-template etcd dnsmasq)
  154. skipping: [10.10.10.10] => (item=node_exporter nginx_exporter blackbox_exporter redis_exporter)
  155. skipping: [10.10.10.10] => (item=ansible python python-pip python-psycopg2)
  156. skipping: [10.10.10.10] => (item=python3 python3-psycopg2 python36-requests python3-etcd python3-consul python36-urllib3 python36-idna python36-pyOpenSSL python36-cryptography)
  157. skipping: [10.10.10.10] => (item=patroni patroni-consul patroni-etcd pgbouncer pg_cli pgbadger pg_activity tail_n_mail)
  158. skipping: [10.10.10.10] => (item=pgcenter boxinfo check_postgres emaj pgbconsole pg_bloat_check pgquarrel barman barman-cli pgloader pgFormatter pitrery pspg pgxnclient PyGreSQL)
  159. skipping: [10.10.10.10] => (item=postgresql14* postgis32_14* citus_14* pglogical_14* timescaledb-2-postgresql-14 pg_repack_14 wal2json_14)
  160. skipping: [10.10.10.10] => (item=pg_qualstats_14 pg_stat_kcache_14 pg_stat_monitor_14 pg_top_14 pg_track_settings_14 pg_wait_sampling_14 pg_probackup-std-14)
  161. skipping: [10.10.10.10] => (item=pg_statement_rollback_14 system_stats_14 plproxy_14 plsh_14 pldebugger_14 plpgsql_check_14 pgmemcache_14)
  162. skipping: [10.10.10.10] => (item=mysql_fdw_14 ogr_fdw_14 tds_fdw_14 sqlite_fdw_14 firebird_fdw_14 hdfs_fdw_14 mongo_fdw_14 osm_fdw_14 pgbouncer_fdw_14)
  163. skipping: [10.10.10.10] => (item=hypopg_14 geoip_14 rum_14 hll_14 ip4r_14 prefix_14 pguri_14 tdigest_14 topn_14 periods_14)
  164. skipping: [10.10.10.10] => (item=bgw_replstatus_14 count_distinct_14 credcheck_14 ddlx_14 extra_window_functions_14 logerrors_14 mysqlcompat_14 orafce_14)
  165. skipping: [10.10.10.10] => (item=repmgr_14 pg_auth_mon_14 pg_auto_failover_14 pg_background_14 pg_bulkload_14 pg_catcheck_14 pg_comparator_14)
  166. skipping: [10.10.10.10] => (item=pg_cron_14 pg_fkpart_14 pg_jobmon_14 pg_partman_14 pg_permissions_14 pg_prioritize_14 pgagent_14)
  167. skipping: [10.10.10.10] => (item=pgaudit16_14 pgauditlogtofile_14 pgcryptokey_14 pgexportdoc_14 pgfincore_14 pgimportdoc_14 powa_14 pgmp_14 pgq_14)
  168. skipping: [10.10.10.10] => (item=pgquarrel-0.7.0-1 pgsql_tweaks_14 pgtap_14 pgtt_14 postgresql-unit_14 postgresql_anonymizer_14 postgresql_faker_14)
  169. skipping: [10.10.10.10] => (item=safeupdate_14 semver_14 set_user_14 sslutils_14 table_version_14)
  170. skipping: [10.10.10.10] => (item=clang coreutils diffutils rpm-build rpm-devel rpmlint rpmdevtools bison flex)
  171. skipping: [10.10.10.10] => (item=docker-ce docker-compose kubelet kubectl kubeadm kubernetes-cni helm)
  173. TASK [Create local repo] *****************************************************************************
  174. skipping: [10.10.10.10]
  176. PLAY [Meta Node Init] ********************************************************************************
  178. TASK [Set hostname from nodename] ********************************************************************
  179. changed: [10.10.10.10]
  181. TASK [node : Fetch hostname from server] *************************************************************
  182. skipping: [10.10.10.10]
  184. TASK [node : Exchange hostname among servers] ********************************************************
  185. skipping: [10.10.10.10]
  187. TASK [node : Write static dns records to /etc/hosts] *************************************************
  188. changed: [10.10.10.10] => (item=10.10.10.10 meta pigsty p.pigsty g.pigsty a.pigsty c.pigsty l.pigsty)
  189. changed: [10.10.10.10] => (item=10.10.10.10 api.pigsty adm.pigsty cli.pigsty ddl.pigsty lab.pigsty git.pigsty sss.pigsty)
  191. TASK [node : Write extra static dns records to /etc/hosts] *******************************************
  193. TASK [node : Get old nameservers] ********************************************************************
  194. changed: [10.10.10.10]
  196. TASK [node : Write tmp resolv file] ******************************************************************
  197. changed: [10.10.10.10]
  199. TASK [node : Write resolv options] *******************************************************************
  200. changed: [10.10.10.10] => (item=options single-request-reopen timeout:1 rotate)
  201. changed: [10.10.10.10] => (item=domain service.consul)
  203. TASK [node : Write additional nameservers] ***********************************************************
  204. changed: [10.10.10.10] => (item=10.10.10.10)
  206. TASK [node : Append existing nameservers] ************************************************************
  207. changed: [10.10.10.10] => (item=10.0.2.3)
  209. TASK [node : Swap resolv.conf] ***********************************************************************
  210. changed: [10.10.10.10]
  212. TASK [node : Node configure disable firewall] ********************************************************
  213. ok: [10.10.10.10]
  215. TASK [node : Node disable selinux by default] ********************************************************
  216. [WARNING]: SELinux state change will take effect next reboot
  217. ok: [10.10.10.10]
  219. TASK [node : Backup existing repos] ******************************************************************
  220. changed: [10.10.10.10]
  222. TASK [node : Install upstream repo] ******************************************************************
  223. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Base', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/os/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/os/$basearch/', u'http://mirror.centos.org/centos/$releasever/os/$basearch/'], u'name': u'base'})
  224. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Updates', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/updates/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/updates/$basearch/', u'http://mirror.centos.org/centos/$releasever/updates/$basearch/'], u'name': u'updates'})
  225. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Extras', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/extras/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/extras/$basearch/', u'http://mirror.centos.org/centos/$releasever/extras/$basearch/'], u'name': u'extras'})
  226. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS $releasever - epel', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/epel/$releasever/$basearch', u'http://mirrors.aliyun.com/epel/$releasever/$basearch', u'http://download.fedoraproject.org/pub/epel/$releasever/$basearch'], u'name': u'epel'})
  227. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'enabled': True, u'description': u'Grafana', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/grafana/yum/rpm', u'https://packages.grafana.com/oss/rpm'], u'name': u'grafana'})
  228. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'Prometheus and exporters', u'baseurl': u'https://packagecloud.io/prometheus-rpm/release/el/$releasever/$basearch', u'name': u'prometheus'})
  229. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'PostgreSQL common RPMs for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'http://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/common/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg-common'})
  230. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'PostgreSQL 14 for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/14/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg14'})
  231. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'TimescaleDB for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://packagecloud.io/timescale/timescaledb/el/7/$basearch'], u'name': u'timescaledb'})
  232. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/sclo/', u'name': u'centos-sclo'})
  233. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo rh', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/rh/', u'name': u'centos-sclo-rh'})
  234. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'nginx', u'baseurl': u'http://nginx.org/packages/centos/$releasever/$basearch/', u'description': u'Nginx Official Yum Repo'})
  235. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'harbottle', u'baseurl': u'https://download.copr.fedorainfracloud.org/results/harbottle/main/epel-$releasever-$basearch/', u'description': u'Copr repo for main owned by harbottle'})
  236. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'pg_probackup', u'baseurl': u'https://repo.postgrespro.ru/pg_probackup-forks/rpm/latest/centos-$releasever-$basearch', u'description': u'PG_PROBACKUP Centos packages for PostgresPro Standard and Enterprise - $basearch'})
  237. skipping: [10.10.10.10] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'docker-ce', u'baseurl': [u'https://mirrors.aliyun.com/docker-ce/linux/centos/$releasever/$basearch/stable', u'https://download.docker.com/linux/centos/$releasever/$basearch/stable'], u'description': u'Docker CE Stable - $basearch'})
  239. TASK [node : Install local repo] *********************************************************************
  240. changed: [10.10.10.10] => (item=http://pigsty/pigsty.repo)
  242. TASK [Install node basic packages] *******************************************************************
  243. skipping: [10.10.10.10] => (item=[])
  245. TASK [Install node extra packages] *******************************************************************
  247. TASK [node : Install meta specific packages] *********************************************************
  248. skipping: [10.10.10.10] => (item=[])
  250. TASK [Install node basic packages] *******************************************************************
  251. changed: [10.10.10.10] => (item=[u'wget,sshpass,ntp,chrony,tuned,uuid,lz4,make,patch,bash,lsof,wget,unzip,git,ftp,vim-minimal,ca-certificates', u'numactl,grubby,sysstat,dstat,iotop,bind-utils,net-tools,tcpdump,socat,ipvsadm,telnet,tuned,nc,pv,jq,perf', u'readline,zlib,openssl,openssl-libs,openssh-clients,python3,python36-requests,node_exporter,consul,etcd,promtail'])
  253. TASK [Install node extra packages] *******************************************************************
  255. TASK [node : Install meta specific packages] *********************************************************
  256. changed: [10.10.10.10] => (item=[u'grafana,prometheus2,alertmanager,loki,nginx_exporter,blackbox_exporter,pushgateway,redis,postgresql14', u'nginx,ansible,pgbadger,python-psycopg2,dnsmasq,coreutils,diffutils,polysh,docker-ce,docker-compose'])
  258. TASK [Install pip3 packages on meta node] ************************************************************
  259. changed: [10.10.10.10]
  261. TASK [node : Node configure disable numa] ************************************************************
  262. skipping: [10.10.10.10]
  264. TASK [node : Node configure disable swap] ************************************************************
  265. skipping: [10.10.10.10]
  267. TASK [node : Node configure unmount swap] ************************************************************
  268. skipping: [10.10.10.10] => (item=swap)
  269. skipping: [10.10.10.10] => (item=none)
  271. TASK [node : Node setup static network] **************************************************************
  272. changed: [10.10.10.10]
  274. TASK [node : Node configure disable firewall] ********************************************************
  275. changed: [10.10.10.10]
  277. TASK [node : Node configure disk prefetch] ***********************************************************
  278. skipping: [10.10.10.10]
  280. TASK [node : Enable linux kernel modules] ************************************************************
  281. changed: [10.10.10.10] => (item=softdog)
  282. changed: [10.10.10.10] => (item=br_netfilter)
  283. changed: [10.10.10.10] => (item=ip_vs)
  284. changed: [10.10.10.10] => (item=ip_vs_rr)
  285. ok: [10.10.10.10] => (item=ip_vs_rr)
  286. changed: [10.10.10.10] => (item=ip_vs_wrr)
  287. changed: [10.10.10.10] => (item=ip_vs_sh)
  289. TASK [node : Enable kernel module on reboot] *********************************************************
  290. changed: [10.10.10.10]
  292. TASK [node : Get config parameter page count] ********************************************************
  293. changed: [10.10.10.10]
  295. TASK [node : Get config parameter page size] *********************************************************
  296. changed: [10.10.10.10]
  298. TASK [node : Tune shmmax and shmall via mem] *********************************************************
  299. skipping: [10.10.10.10]
  301. TASK [node : Create tuned profiles] ******************************************************************
  302. changed: [10.10.10.10] => (item=oltp)
  303. changed: [10.10.10.10] => (item=olap)
  304. changed: [10.10.10.10] => (item=crit)
  305. changed: [10.10.10.10] => (item=tiny)
  307. TASK [node : Render tuned profiles] ******************************************************************
  308. changed: [10.10.10.10] => (item=oltp)
  309. changed: [10.10.10.10] => (item=olap)
  310. changed: [10.10.10.10] => (item=crit)
  311. changed: [10.10.10.10] => (item=tiny)
  313. TASK [node : Active tuned profile] *******************************************************************
  314. changed: [10.10.10.10]
  316. TASK [node : Change additional sysctl params] ********************************************************
  318. TASK [node : Copy default user bash profile] *********************************************************
  319. changed: [10.10.10.10]
  321. TASK [Setup node default pam ulimits] ****************************************************************
  322. changed: [10.10.10.10]
  324. TASK [Create node data dir if exists] ****************************************************************
  325. changed: [10.10.10.10]
  327. TASK [node : Create os user group admin] *************************************************************
  328. changed: [10.10.10.10]
  330. TASK [node : Create os user admin] *******************************************************************
  331. changed: [10.10.10.10]
  333. TASK [node : Grant admin group nopass sudo] **********************************************************
  334. changed: [10.10.10.10]
  336. TASK [node : Add no host checking to ssh config] *****************************************************
  337. changed: [10.10.10.10]
  339. TASK [node : Add admin ssh no host checking] *********************************************************
  340. ok: [10.10.10.10]
  342. TASK [node : Fetch all admin public keys] ************************************************************
  343. changed: [10.10.10.10]
  345. TASK [node : Exchange all admin ssh keys] ************************************************************
  346. changed: [10.10.10.10 -> 10.10.10.10] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDPzzw6XqahkKgDyQunmjTQEfs5+28oPrhW02REQBlhsw58dlTJWnfQEQFB4BTGznT5Xd4wcqp4nNNbiznWikwgD0rhYMFdxmFClyYXCDllSkzpQqFIbDlt+/9MmzSfAA64n0goffgJC1MbiZXBsrSsteNq96qGkDZpaQXp5PIeeoLiVkwI5GICGHIoKj4vnPUjzgLnRo0hr9K+bJ8os972AcbzxEh/dlMs71PRbIvPD46lxWy6zdINk1fd8XBdMmuoynVRuehUsOd72m1umLCK9fXWAilU1oSRT25y5SLQqQZ+dhHyxKL+wuu03vLHWrDGo/+0ocYEqH261JgQInF5 ansible-generated on pg-meta-1', u'10.10.10.10'])
  348. TASK [node : Install public keys] ********************************************************************
  349. changed: [10.10.10.10] => (item=ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAAAgQC7IMAMNavYtWwzAJajKqwdn3ar5BhvcwCnBTxxEkXhGlCO2vfgosSAQMEflfgvkiI5nM1HIFQ8KINlx1XLO7SdL5KdInG5LIJjAFh0pujS4kNCT9a5IGvSq1BrzGqhbEcwWYdju1ZPYBcJm/MG+JD0dYCh8vfrYB/cYMD0SOmNkQ== vagrant@pigsty.com)
  351. TASK [node : Install current public key] *************************************************************
  352. ok: [10.10.10.10]
  354. TASK [Setup default node timezone] *******************************************************************
  355. changed: [10.10.10.10]
  357. TASK [node : Install ntp package] ********************************************************************
  358. ok: [10.10.10.10]
  360. TASK [node : Install chrony package] *****************************************************************
  361. skipping: [10.10.10.10]
  363. TASK [node : Copy the ntp.conf file] *****************************************************************
  364. changed: [10.10.10.10]
  366. TASK [node : Copy the chrony.conf template] **********************************************************
  367. changed: [10.10.10.10]
  369. TASK [node : Launch ntpd service] ********************************************************************
  370. changed: [10.10.10.10]
  372. TASK [node : Launch chronyd service] *****************************************************************
  373. skipping: [10.10.10.10]
  375. TASK [node : Append /etc/crontab] ********************************************************************
  376. skipping: [10.10.10.10] => (item=00 01 * * * postgres /pg/bin/pg-backup 2>>/pg/log/backup.log)
  377. skipping: [10.10.10.10] => (item=* * * * * postgres /usr/pgsql/bin/pgbench meta -nv -T10 -c2 2>>/pg/log/bench.log)
  379. TASK [node : Overwrite /etc/crontab] *****************************************************************
  380. changed: [10.10.10.10]
  382. TASK [Install docker and docker-compose] *************************************************************
  383. ok: [10.10.10.10] => (item=docker-ce)
  384. ok: [10.10.10.10] => (item=docker-compose)
  386. TASK [docker : Get current admin user] ***************************************************************
  387. changed: [10.10.10.10]
  389. TASK [Add admin user to docker group] ****************************************************************
  390. changed: [10.10.10.10] => (item=vagrant)
  391. changed: [10.10.10.10] => (item=dba)
  393. TASK [Make sure /etc/docker exists] ******************************************************************
  394. changed: [10.10.10.10]
  396. TASK [Overwrite /etc/docker/daemon.json] *************************************************************
  397. changed: [10.10.10.10]
  399. TASK [Launch docker service unit] ********************************************************************
  400. changed: [10.10.10.10]
  402. TASK [Check docker image cache exists] ***************************************************************
  403. ok: [10.10.10.10]
  405. TASK [Load docker image cache if exists] *************************************************************
  406. skipping: [10.10.10.10]
  408. TASK [Check for existing consul] *********************************************************************
  409. changed: [10.10.10.10]
  411. TASK [consul : Consul exists flag fact set] **********************************************************
  412. ok: [10.10.10.10]
  414. TASK [Abort due to existing consul instance] *********************************************************
  415. skipping: [10.10.10.10]
  417. TASK [Clean existing consul instance] ****************************************************************
  418. skipping: [10.10.10.10]
  420. TASK [Stop any running consul instance] **************************************************************
  421. changed: [10.10.10.10]
  423. TASK [Make sure consul is installed] *****************************************************************
  424. ok: [10.10.10.10]
  426. TASK [Create consul dir] *****************************************************************************
  427. changed: [10.10.10.10] => (item=/etc/consul.d)
  428. changed: [10.10.10.10] => (item=/data/consul)
  430. TASK [consul : Fetch hostname from server if no node name is given] **********************************
  431. skipping: [10.10.10.10]
  433. TASK [consul : Setup nodename according to hostname] *************************************************
  434. skipping: [10.10.10.10]
  436. TASK [Make sure consul hcl absent] *******************************************************************
  437. ok: [10.10.10.10]
  439. TASK [Render consul main conf /etc/consul.d/consul.json] *********************************************
  440. changed: [10.10.10.10]
  442. TASK [Render consul node meta /etc/consul.d/consul-meta.json] ****************************************
  443. changed: [10.10.10.10]
  445. TASK [Get consul bootstrap expect quroum] ************************************************************
  446. ok: [10.10.10.10]
  448. TASK [Render consul server /etc/consul.d/consul-server.json] *****************************************
  449. changed: [10.10.10.10]
  451. TASK [Render consul ui conf /etc/consul.d/consul-server.json] ****************************************
  452. changed: [10.10.10.10]
  454. TASK [Copy consul systemd service] *******************************************************************
  455. changed: [10.10.10.10]
  457. TASK [Launch consul server service] ******************************************************************
  458. changed: [10.10.10.10]
  460. TASK [Wait for consul server online] *****************************************************************
  461. ok: [10.10.10.10]
  463. TASK [Launch consul agent service] *******************************************************************
  464. skipping: [10.10.10.10]
  466. TASK [Wait for consul agent online] ******************************************************************
  467. skipping: [10.10.10.10]
  469. TASK [Check for existing etcd] ***********************************************************************
  470. changed: [10.10.10.10]
  472. TASK [etcd : Etcd exists flag fact set] **************************************************************
  473. ok: [10.10.10.10]
  475. TASK [Abort due to etcd exists] **********************************************************************
  476. skipping: [10.10.10.10]
  478. TASK [Clean existing etcd instance] ******************************************************************
  479. skipping: [10.10.10.10]
  481. TASK [Stop any running etcd instance] ****************************************************************
  482. changed: [10.10.10.10]
  484. TASK [Create etcd dir] *******************************************************************************
  485. changed: [10.10.10.10] => (item=/etc/etcd)
  486. changed: [10.10.10.10] => (item=/data/etcd)
  488. TASK [etcd : Get dcs server key as dcs nodename] *****************************************************
  489. ok: [10.10.10.10]
  491. TASK [Copy etcd server service unit] *****************************************************************
  492. changed: [10.10.10.10]
  494. TASK [Copy /etc/etcd.d/etcd.conf] ********************************************************************
  495. changed: [10.10.10.10]
  497. TASK [Launch etcd server service] ********************************************************************
  498. changed: [10.10.10.10]
  500. TASK [Wait for etcd server online] *******************************************************************
  501. ok: [10.10.10.10]
  503. TASK [Write etcd endpoint env profile] ***************************************************************
  504. changed: [10.10.10.10]
  506. PLAY [Setup Infrastructure on meta nodes] ************************************************************
  508. TASK [Create local ca directory] *********************************************************************
  509. changed: [10.10.10.10]
  511. TASK [Copy ca cert from local files] *****************************************************************
  512. skipping: [10.10.10.10] => (item=ca.key)
  513. skipping: [10.10.10.10] => (item=ca.crt)
  515. TASK [Check ca key cert exists] **********************************************************************
  516. ok: [10.10.10.10]
  518. TASK [ca : Create self-signed CA key-cert] ***********************************************************
  519. changed: [10.10.10.10]
  521. TASK [nameserver : Make sure dnsmasq package installed] **********************************************
  522. ok: [10.10.10.10]
  524. TASK [nameserver : Copy dnsmasq /etc/dnsmasq.d/config] ***********************************************
  525. changed: [10.10.10.10]
  527. TASK [nameserver : Add dynamic dns records to meta] **************************************************
  528. changed: [10.10.10.10] => (item=10.10.10.2  pg-meta)
  529. changed: [10.10.10.10] => (item=10.10.10.3  pg-test)
  530. changed: [10.10.10.10] => (item=10.10.10.10 pg-meta-1)
  531. changed: [10.10.10.10] => (item=10.10.10.11 pg-test-1)
  532. changed: [10.10.10.10] => (item=10.10.10.12 pg-test-2)
  533. changed: [10.10.10.10] => (item=10.10.10.13 pg-test-3)
  535. TASK [nameserver : Launch meta dnsmasq service] ******************************************************
  536. skipping: [10.10.10.10]
  538. TASK [nameserver : Wait for meta dnsmasq online] *****************************************************
  539. skipping: [10.10.10.10]
  541. TASK [Make sure nginx installed] *********************************************************************
  542. ok: [10.10.10.10]
  544. TASK [nginx : Create local html directory] ***********************************************************
  545. ok: [10.10.10.10] => (item=/www)
  546. changed: [10.10.10.10] => (item=/www/pev2)
  547. changed: [10.10.10.10] => (item=/www/docs)
  548. changed: [10.10.10.10] => (item=/www/logs)
  549. changed: [10.10.10.10] => (item=/www/schema)
  550. changed: [10.10.10.10] => (item=/www/report)
  552. TASK [nginx : Copy pigsty logo file] *****************************************************************
  553. changed: [10.10.10.10]
  555. TASK [Render default nginx home page] ****************************************************************
  556. changed: [10.10.10.10]
  558. TASK [Create nginx haproxy config dir] ***************************************************************
  559. changed: [10.10.10.10]
  561. TASK [Copy nginx main config] ************************************************************************
  562. changed: [10.10.10.10]
  564. TASK [Copy nginx default config] *********************************************************************
  565. changed: [10.10.10.10]
  567. TASK [Copy nginx upstream conf] **********************************************************************
  568. skipping: [10.10.10.10] => (item={u'domain': u'pigsty', u'endpoint': u'10.10.10.10:80', u'name': u'home'})
  569. changed: [10.10.10.10] => (item={u'domain': u'g.pigsty', u'endpoint': u'10.10.10.10:3000', u'name': u'grafana'})
  570. changed: [10.10.10.10] => (item={u'domain': u'l.pigsty', u'endpoint': u'10.10.10.10:3100', u'name': u'loki'})
  571. changed: [10.10.10.10] => (item={u'domain': u'p.pigsty', u'endpoint': u'10.10.10.10:9090', u'name': u'prometheus'})
  572. changed: [10.10.10.10] => (item={u'domain': u'a.pigsty', u'endpoint': u'10.10.10.10:9093', u'name': u'alertmanager'})
  573. changed: [10.10.10.10] => (item={u'domain': u'c.pigsty', u'endpoint': u'127.0.0.1:8500', u'name': u'consul'})
  574. changed: [10.10.10.10] => (item={u'domain': u'api.pigsty.cc', u'endpoint': u'127.0.0.1:8884', u'name': u'postgrest'})
  575. changed: [10.10.10.10] => (item={u'domain': u'adm.pigsty.cc', u'endpoint': u'127.0.0.1:8885', u'name': u'pgadmin'})
  576. changed: [10.10.10.10] => (item={u'domain': u'cli.pigsty.cc', u'endpoint': u'127.0.0.1:8886', u'name': u'pgweb'})
  577. changed: [10.10.10.10] => (item={u'domain': u'ddl.pigsty.cc', u'endpoint': u'127.0.0.1:8887', u'name': u'bytebase'})
  578. changed: [10.10.10.10] => (item={u'domain': u'lab.pigsty.cc', u'endpoint': u'127.0.0.1:8888', u'name': u'jupyter'})
  579. changed: [10.10.10.10] => (item={u'domain': u'git.pigsty.cc', u'endpoint': u'127.0.0.1:8889', u'name': u'gitea'})
  580. changed: [10.10.10.10] => (item={u'domain': u'sss.pigsty.cc', u'endpoint': u'127.0.0.1:9000', u'name': u'minio'})
  582. TASK [nginx : Setup docs if exists] ******************************************************************
  583. changed: [10.10.10.10]
  585. TASK [nginx : Setup pev2 if exists] ******************************************************************
  586. changed: [10.10.10.10]
  588. TASK [Restart meta nginx service] ********************************************************************
  589. changed: [10.10.10.10]
  591. TASK [Wait for nginx service online] *****************************************************************
  592. ok: [10.10.10.10]
  594. TASK [Make sure nginx exporter installed] ************************************************************
  595. ok: [10.10.10.10]
  597. TASK [Config nginx_exporter options] *****************************************************************
  598. changed: [10.10.10.10]
  600. TASK [Restart nginx_exporter service] ****************************************************************
  601. changed: [10.10.10.10]
  603. TASK [Wait for nginx exporter online] ****************************************************************
  604. ok: [10.10.10.10]
  606. TASK [Install prometheus and alertmanager] ***********************************************************
  607. ok: [10.10.10.10] => (item=prometheus2)
  608. ok: [10.10.10.10] => (item=alertmanager)
  610. TASK [Wipe out prometheus config dir] ****************************************************************
  611. changed: [10.10.10.10]
  613. TASK [Wipe out existing prometheus data] *************************************************************
  614. ok: [10.10.10.10]
  616. TASK [Create prometheus directories] *****************************************************************
  617. changed: [10.10.10.10] => (item=/etc/prometheus)
  618. changed: [10.10.10.10] => (item=/etc/prometheus/bin)
  619. changed: [10.10.10.10] => (item=/etc/prometheus/rules)
  620. changed: [10.10.10.10] => (item=/etc/prometheus/targets)
  621. changed: [10.10.10.10] => (item=/etc/prometheus/targets/infra)
  622. changed: [10.10.10.10] => (item=/etc/prometheus/targets/nodes)
  623. changed: [10.10.10.10] => (item=/etc/prometheus/targets/pgsql)
  624. changed: [10.10.10.10] => (item=/etc/prometheus/targets/redis)
  625. changed: [10.10.10.10] => (item=/data/prometheus/data)
  627. TASK [Copy prometheus bin scripts] *******************************************************************
  628. changed: [10.10.10.10]
  630. TASK [Copy prometheus rules] *************************************************************************
  631. changed: [10.10.10.10]
  633. TASK [Render prometheus config] **********************************************************************
  634. changed: [10.10.10.10]
  636. TASK [prometheus : Render altermanager config] *******************************************************
  637. changed: [10.10.10.10]
  639. TASK [Config /etc/prometheus opts] *******************************************************************
  640. changed: [10.10.10.10]
  642. TASK [Launch prometheus service] *********************************************************************
  643. changed: [10.10.10.10]
  645. TASK [Wait for prometheus online] ********************************************************************
  646. ok: [10.10.10.10]
  648. TASK [prometheus : Launch alertmanager service] ******************************************************
  649. changed: [10.10.10.10]
  651. TASK [prometheus : Wait for alertmanager online] *****************************************************
  652. ok: [10.10.10.10]
  654. TASK [Reload prometheus service] *********************************************************************
  655. changed: [10.10.10.10]
  657. TASK [Make sure grafana installed] *******************************************************************
  658. ok: [10.10.10.10]
  660. TASK [Stop grafana service] **************************************************************************
  661. changed: [10.10.10.10]
  663. TASK [Check grafana plugin cache exists] *************************************************************
  664. ok: [10.10.10.10]
  666. TASK [Provision grafana plugins via cache if exists] *************************************************
  667. changed: [10.10.10.10]
  669. TASK [Download grafana plugins via internet] *********************************************************
  670. skipping: [10.10.10.10] => (item=marcusolsson-csv-datasource)
  671. skipping: [10.10.10.10] => (item=marcusolsson-json-datasource)
  672. skipping: [10.10.10.10] => (item=marcusolsson-treemap-panel)
  674. TASK [Download grafana plugins via git] **************************************************************
  675. skipping: [10.10.10.10] => (item=https://github.com/Vonng/vonng-echarts-panel)
  677. TASK [Remove grafana provisioning config] ************************************************************
  678. ok: [10.10.10.10] => (item=/etc/grafana/provisioning/dashboards/pigsty.yml)
  679. ok: [10.10.10.10] => (item=/etc/grafana/provisioning/datasources/pigsty.yml)
  681. TASK [Remake grafana resource dir] *******************************************************************
  682. changed: [10.10.10.10] => (item=/etc/grafana/)
  683. changed: [10.10.10.10] => (item=/etc/dashboards)
  684. changed: [10.10.10.10] => (item=/etc/grafana/provisioning/dashboards)
  685. changed: [10.10.10.10] => (item=/etc/grafana/provisioning/datasources)
  687. TASK [Copy grafana systemd service] ******************************************************************
  688. changed: [10.10.10.10]
  690. TASK [Templating /etc/grafana/grafana.ini] ***********************************************************
  691. changed: [10.10.10.10]
  693. TASK [grafana : Templating datasources provisioning config] ******************************************
  694. changed: [10.10.10.10]
  696. TASK [grafana : Templating dashboards provisioning config] *******************************************
  697. changed: [10.10.10.10]
  699. TASK [Customize grafana logo icon] *******************************************************************
  700. changed: [10.10.10.10]
  702. TASK [Launch grafana service] ************************************************************************
  703. changed: [10.10.10.10]
  705. TASK [Wait for grafana online] ***********************************************************************
  706. ok: [10.10.10.10]
  708. TASK [Sync grafana home and core dashboards] *********************************************************
  709. changed: [10.10.10.10]
  711. TASK [Provisioning grafana with grafana.py] **********************************************************
  712. changed: [10.10.10.10]
  714. TASK [Install loki via yum] **************************************************************************
  715. ok: [10.10.10.10]
  717. TASK [Cleanup loki] **********************************************************************************
  718. skipping: [10.10.10.10]
  720. TASK [Make sure loki data & rule dir exists] *********************************************************
  721. changed: [10.10.10.10]
  723. TASK [Copy loki systemd service] *********************************************************************
  724. ok: [10.10.10.10]
  726. TASK [Templating loki.yml main config] ***************************************************************
  727. changed: [10.10.10.10]
  729. TASK [Render loki default config] ********************************************************************
  730. changed: [10.10.10.10]
  732. TASK [loki : Launch Loki] ****************************************************************************
  733. changed: [10.10.10.10]
  735. TASK [Wait for loki online] **************************************************************************
  736. ok: [10.10.10.10]
  738. TASK [infra_register : Register nginx service to consul] *********************************************
  739. changed: [10.10.10.10]
  741. TASK [infra_register : Register nginx-exporter service to consul] ************************************
  742. changed: [10.10.10.10]
  744. TASK [infra_register : Register prometheus service to consul] ****************************************
  745. changed: [10.10.10.10]
  747. TASK [infra_register : Register alertmanager service to consul] **************************************
  748. changed: [10.10.10.10]
  750. TASK [infra_register : Register grafana service to consul] *******************************************
  751. changed: [10.10.10.10]
  753. TASK [infra_register : Register loki service to consul] **********************************************
  754. changed: [10.10.10.10]
  756. TASK [infra_register : Register dnsmasq service to consul] *******************************************
  757. skipping: [10.10.10.10]
  759. TASK [infra_register : Reload consul] ****************************************************************
  760. changed: [10.10.10.10]
  762. TASK [infra_register : Render infra file-sd targets targets for prometheus] **************************
  763. changed: [10.10.10.10 -> 10.10.10.10] => (item=10.10.10.10)
  765. PLAY [Meta Node Monitor] *****************************************************************************
  767. TASK [Add yum repo for node_exporter] ****************************************************************
  768. skipping: [10.10.10.10]
  770. TASK [Install node_exporter via yum] *****************************************************************
  771. skipping: [10.10.10.10]
  773. TASK [Install node_exporter via binary] **************************************************************
  774. skipping: [10.10.10.10]
  776. TASK [Config node_exporter systemd unit] *************************************************************
  777. changed: [10.10.10.10]
  779. TASK [Config default node_exporter options] **********************************************************
  780. changed: [10.10.10.10]
  782. TASK [Launch node_exporter systemd unit] *************************************************************
  783. changed: [10.10.10.10]
  785. TASK [Wait for node_exporter online] *****************************************************************
  786. ok: [10.10.10.10]
  788. TASK [Install promtail via yum] **********************************************************************
  789. ok: [10.10.10.10]
  791. TASK [Cleanup promtail positions] ********************************************************************
  792. skipping: [10.10.10.10]
  794. TASK [Copy promtail systemd service] *****************************************************************
  795. ok: [10.10.10.10]
  797. TASK [promtail : Fetch hostname from server if no node name is given] ********************************
  798. skipping: [10.10.10.10]
  800. TASK [promtail : Setup nodename according to hostname] ***********************************************
  801. skipping: [10.10.10.10]
  803. TASK [Render promtail main config] *******************************************************************
  804. changed: [10.10.10.10]
  806. TASK [Render promtail default config] ****************************************************************
  807. changed: [10.10.10.10]
  809. TASK [Launch promtail] *******************************************************************************
  810. changed: [10.10.10.10]
  812. TASK [Wait for promtail online] **********************************************************************
  813. ok: [10.10.10.10]
  815. TASK [node_register : Fetch hostname from server if no node name is given] ***************************
  816. skipping: [10.10.10.10]
  818. TASK [node_register : Setup nodename according to hostname] ******************************************
  819. skipping: [10.10.10.10]
  821. TASK [node_register : Register docker service to consul] *********************************************
  822. changed: [10.10.10.10]
  824. TASK [node_register : Register node-exporter service to consul] **************************************
  825. changed: [10.10.10.10]
  827. TASK [node_register : Register promtail service to consul] *******************************************
  828. changed: [10.10.10.10]
  830. TASK [node_register : Reload consul] *****************************************************************
  831. changed: [10.10.10.10]
  833. TASK [node_register : Fetch hostname from server if no node name is given] ***************************
  834. skipping: [10.10.10.10]
  836. TASK [node_register : Setup nodename according to hostname] ******************************************
  837. skipping: [10.10.10.10]
  839. TASK [node_register : Register node exporter as prometheus target] ***********************************
  840. changed: [10.10.10.10 -> 10.10.10.10] => (item=10.10.10.10)
  842. PLAY [Meta PGSQL Init] *******************************************************************************
  844. TASK [Create os group postgres] **********************************************************************
  845. changed: [10.10.10.10]
  847. TASK [postgres : Make sure dcs group exists] *********************************************************
  848. ok: [10.10.10.10] => (item=consul)
  849. ok: [10.10.10.10] => (item=etcd)
  851. TASK [Create dbsu postgres] **************************************************************************
  852. changed: [10.10.10.10]
  854. TASK [postgres : Grant dbsu nopass sudo] *************************************************************
  855. skipping: [10.10.10.10]
  857. TASK [postgres : Grant dbsu all sudo] ****************************************************************
  858. skipping: [10.10.10.10]
  860. TASK [postgres : Grant dbsu limited sudo] ************************************************************
  861. changed: [10.10.10.10]
  863. TASK [postgres : Config watchdog onwer to dbsu] ******************************************************
  864. changed: [10.10.10.10]
  866. TASK [postgres : Add dbsu ssh no host checking] ******************************************************
  867. changed: [10.10.10.10]
  869. TASK [postgres : Fetch dbsu public keys] *************************************************************
  870. changed: [10.10.10.10]
  872. TASK [postgres : Exchange dbsu ssh keys] *************************************************************
  873. changed: [10.10.10.10 -> 10.10.10.10] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDTnoEpVwp2k88FlqB16plsoYpvXVv9BIPajheil8DGMsgir/IHYT9pQhhLrKfStV9zZiLu96oCjTqHQdzKt04gbEcT/kD4kdnVrpbA/Z7CcoDlahHDEcRZoVPTL0Ba+TNKc9UslDm3JxgxLFr2KDigC0AoG8xzGGdHSxsPdlDz59/n+7WWJRuE5jicPIwVy70KNaSdlYfYnqlnWHhAwNXROsLoKiTBoYsxIRuuQfWEZsUmxDhwJ3ESUUgEE+F5B7R2/wh/UBcBZRfDpc4OzNkZKLiQz3UJ+P6FkQJD5Uy1ZfoPdF8cVFNoPSBpN3KJ0jXiEe6cNBbstsGkCmd6DxFD ansible-generated on pg-meta-1', u'10.10.10.10'])
  875. TASK [postgres : Install offical pgdg yum repo] ******************************************************
  876. skipping: [10.10.10.10] => (item=postgresql${pg_version}*)
  877. skipping: [10.10.10.10] => (item=postgis32_${pg_version}*)
  878. skipping: [10.10.10.10] => (item=citus_${pg_version}*)
  879. skipping: [10.10.10.10] => (item=timescaledb-2-postgresql-${pg_version})
  880. skipping: [10.10.10.10] => (item=pgbouncer pg_exporter pgbadger pg_activity node_exporter consul haproxy vip-manager)
  881. skipping: [10.10.10.10] => (item=patroni patroni-consul patroni-etcd python3 python3-psycopg2 python36-requests python3-etcd)
  882. skipping: [10.10.10.10] => (item=python3-consul python36-urllib3 python36-idna python36-pyOpenSSL python36-cryptography)
  884. TASK [postgres : Install pg packages] ****************************************************************
  885. changed: [10.10.10.10] => (item=[u'postgresql14*', u'postgis32_14*', u'citus_14*', u'timescaledb-2-postgresql-14', u'pgbouncer,pg_exporter,pgbadger,pg_activity,node_exporter,consul,haproxy,vip-manager', u'patroni,patroni-consul,patroni-etcd,python3,python3-psycopg2,python36-requests,python3-etcd', u'python3-consul,python36-urllib3,python36-idna,python36-pyOpenSSL,python36-cryptography'])
  887. TASK [postgres : Install pg extensions] **************************************************************
  888. changed: [10.10.10.10] => (item=[u'pg_repack_14,pg_qualstats_14,pg_stat_kcache_14,pg_stat_monitor_14,wal2json_14'])
  890. TASK [postgres : Link /usr/pgsql to current version] *************************************************
  891. changed: [10.10.10.10]
  893. TASK [postgres : Add pg bin dir to profile path] *****************************************************
  894. changed: [10.10.10.10]
  896. TASK [postgres : Fix directory ownership] ************************************************************
  897. ok: [10.10.10.10]
  899. TASK [Remove default postgres service] ***************************************************************
  900. changed: [10.10.10.10]
  902. TASK [postgres : Check necessary variables exists] ***************************************************
  903. ok: [10.10.10.10] => {
  904.     "changed": false,
  905.     "msg": "All assertions passed"
  906. }
  908. TASK [postgres : Fetch variables via pg_cluster] *****************************************************
  909. ok: [10.10.10.10]
  911. TASK [postgres : Set cluster basic facts for hosts] **************************************************
  912. ok: [10.10.10.10]
  914. TASK [postgres : Assert cluster primary singleton] ***************************************************
  915. ok: [10.10.10.10] => {
  916.     "changed": false,
  917.     "msg": "All assertions passed"
  918. }
  920. TASK [postgres : Setup cluster primary ip address] ***************************************************
  921. ok: [10.10.10.10]
  923. TASK [postgres : Setup repl upstream for primary] ****************************************************
  924. skipping: [10.10.10.10]
  926. TASK [postgres : Setup repl upstream for replicas] ***************************************************
  927. skipping: [10.10.10.10]
  929. TASK [postgres : Debug print instance summary] *******************************************************
  930. ok: [10.10.10.10] => {
  931.     "msg": "cluster=pg-meta service=pg-meta-primary instance=pg-meta-1 replication=[primary:itself]->10.10.10.10"
  932. }
  934. TASK [Check for existing postgres instance] **********************************************************
  935. changed: [10.10.10.10]
  937. TASK [postgres : Set fact whether pg port is open] ***************************************************
  938. ok: [10.10.10.10]
  940. TASK [Abort due to existing postgres instance] *******************************************************
  941. skipping: [10.10.10.10]
  943. TASK [postgres : CLEAN RUNNING POSTGRESQL INSTANCE <DANGEROUSE!>] ************************************
  944. skipping: [10.10.10.10]
  946. TASK [Shutdown existing postgres service] ************************************************************
  947. changed: [10.10.10.10]
  949. TASK [postgres : Remove registerd consul service] ****************************************************
  950. changed: [10.10.10.10]
  952. TASK [Remove postgres metadata in consul] ************************************************************
  953. changed: [10.10.10.10]
  955. TASK [Remove postgres metadata in etcd] **************************************************************
  956. skipping: [10.10.10.10]
  958. TASK [Remove existing postgres data] *****************************************************************
  959. ok: [10.10.10.10] => (item=/pg)
  960. ok: [10.10.10.10] => (item=/data/postgres)
  961. ok: [10.10.10.10] => (item=/data/backups/postgres)
  962. changed: [10.10.10.10] => (item=/etc/pgbouncer)
  963. changed: [10.10.10.10] => (item=/var/log/pgbouncer)
  964. changed: [10.10.10.10] => (item=/var/run/pgbouncer)
  966. TASK [postgres : Make sure main and backup dir exists] ***********************************************
  967. ok: [10.10.10.10] => (item=/data)
  968. changed: [10.10.10.10] => (item=/data/backups)
  970. TASK [Create postgres directory structure] ***********************************************************
  971. changed: [10.10.10.10] => (item=/data/postgres)
  972. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14)
  973. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/bin)
  974. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/log)
  975. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/tmp)
  976. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/conf)
  977. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/data)
  978. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/meta)
  979. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/stat)
  980. changed: [10.10.10.10] => (item=/data/postgres/pg-meta-14/change)
  981. changed: [10.10.10.10] => (item=/data/backups/postgres/pg-meta-14/postgres)
  982. changed: [10.10.10.10] => (item=/data/backups/postgres/pg-meta-14/arcwal)
  983. changed: [10.10.10.10] => (item=/data/backups/postgres/pg-meta-14/backup)
  984. changed: [10.10.10.10] => (item=/data/backups/postgres/pg-meta-14/remote)
  986. TASK [postgres : Create pgbouncer directory structure] ***********************************************
  987. changed: [10.10.10.10] => (item=/etc/pgbouncer)
  988. changed: [10.10.10.10] => (item=/var/log/pgbouncer)
  989. changed: [10.10.10.10] => (item=/var/run/pgbouncer)
  991. TASK [postgres : Create links from pgbkup to pgroot] *************************************************
  992. changed: [10.10.10.10] => (item=arcwal)
  993. changed: [10.10.10.10] => (item=backup)
  994. changed: [10.10.10.10] => (item=remote)
  996. TASK [postgres : Create links from current cluster] **************************************************
  997. changed: [10.10.10.10]
  999. TASK [postgres : Create dummy placeholder file] ******************************************************
  1000. changed: [10.10.10.10]
  1002. TASK [Copy postgres scripts to /pg/bin/] *************************************************************
  1003. changed: [10.10.10.10]
  1005. TASK [postgres : Copy alias profile to /etc/profile.d] ***********************************************
  1006. changed: [10.10.10.10]
  1008. TASK [Copy psqlrc to postgres home] ******************************************************************
  1009. changed: [10.10.10.10]
  1011. TASK [postgres : Get config parameter page count] ****************************************************
  1012. changed: [10.10.10.10]
  1014. TASK [postgres : Get config parameter page size] *****************************************************
  1015. changed: [10.10.10.10]
  1017. TASK [postgres : Tune shared buffer and work mem] ****************************************************
  1018. ok: [10.10.10.10]
  1020. TASK [postgres : Hanlde small size mem occasion] *****************************************************
  1021. ok: [10.10.10.10]
  1023. TASK [Calculate postgres mem params] *****************************************************************
  1024. skipping: [10.10.10.10]
  1026. TASK [postgres : create patroni config dir] **********************************************************
  1027. changed: [10.10.10.10]
  1029. TASK [postgres : use predefined patroni template] ****************************************************
  1030. skipping: [10.10.10.10]
  1032. TASK [postgres : Render default /pg/conf/patroni.yml] ************************************************
  1033. changed: [10.10.10.10]
  1035. TASK [postgres : Link /pg/conf/patroni to /pg/bin/] **************************************************
  1036. changed: [10.10.10.10]
  1038. TASK [postgres : Link /pg/bin/patroni.yml to /etc/patroni/] ******************************************
  1039. changed: [10.10.10.10]
  1041. TASK [postgres : Config patroni watchdog support] ****************************************************
  1042. ok: [10.10.10.10]
  1044. TASK [postgres : Copy patroni systemd service file] **************************************************
  1045. changed: [10.10.10.10]
  1047. TASK [postgres : create patroni systemd drop-in dir] *************************************************
  1048. changed: [10.10.10.10]
  1050. TASK [Copy postgres systemd service file] ************************************************************
  1051. changed: [10.10.10.10]
  1053. TASK [postgres : Drop-In systemd config for patroni] *************************************************
  1054. changed: [10.10.10.10]
  1056. TASK [postgres : Launch patroni on primary instance] *************************************************
  1057. changed: [10.10.10.10]
  1059. TASK [postgres : Wait for patroni primary online] ****************************************************
  1060. ok: [10.10.10.10]
  1062. TASK [Wait for postgres primary online] **************************************************************
  1063. ok: [10.10.10.10]
  1065. TASK [Check primary postgres service ready] **********************************************************
  1066. [WARNING]: Module remote_tmp /var/lib/pgsql/.ansible/tmp did not exist and was created with a mode of
  1067. 0700, this may cause issues when running as another user. To avoid this, create the remote_tmp dir
  1068. with the correct permissions manually
  1069. changed: [10.10.10.10]
  1071. TASK [postgres : Check replication connectivity on primary] ******************************************
  1072. changed: [10.10.10.10]
  1074. TASK [postgres : Render init roles sql] **************************************************************
  1075. changed: [10.10.10.10]
  1077. TASK [postgres : Render init template sql] ***********************************************************
  1078. changed: [10.10.10.10]
  1080. TASK [postgres : Render default pg-init scripts] *****************************************************
  1081. changed: [10.10.10.10]
  1083. TASK [postgres : Execute initialization scripts] *****************************************************
  1084. changed: [10.10.10.10]
  1086. TASK [postgres : Check primary instance ready] *******************************************************
  1087. changed: [10.10.10.10]
  1089. TASK [postgres : Add dbsu password to pgpass if exists] **********************************************
  1090. skipping: [10.10.10.10]
  1092. TASK [postgres : Add system user to pgpass] **********************************************************
  1093. changed: [10.10.10.10] => (item={u'username': u'replicator', u'password': u'DBUser.Replicator'})
  1094. changed: [10.10.10.10] => (item={u'username': u'dbuser_monitor', u'password': u'DBUser.Monitor'})
  1095. changed: [10.10.10.10] => (item={u'username': u'dbuser_dba', u'password': u'DBUser.DBA'})
  1097. TASK [postgres : Check replication connectivity to primary] ******************************************
  1098. skipping: [10.10.10.10]
  1100. TASK [postgres : Launch patroni on replica instances] ************************************************
  1101. skipping: [10.10.10.10]
  1103. TASK [postgres : Wait for patroni replica online] ****************************************************
  1104. skipping: [10.10.10.10]
  1106. TASK [Wait for postgres replica online] **************************************************************
  1107. skipping: [10.10.10.10]
  1109. TASK [Check replica postgres service ready] **********************************************************
  1110. skipping: [10.10.10.10]
  1112. TASK [postgres : Render hba rules] *******************************************************************
  1113. changed: [10.10.10.10]
  1115. TASK [postgres : Reload hba rules] *******************************************************************
  1116. changed: [10.10.10.10]
  1118. TASK [postgres : Reload patroni] *********************************************************************
  1119. changed: [10.10.10.10]
  1121. TASK [postgres : Pause patroni] **********************************************************************
  1122. skipping: [10.10.10.10]
  1124. TASK [postgres : Stop patroni on replica instance] ***************************************************
  1125. skipping: [10.10.10.10]
  1127. TASK [postgres : Stop patroni on primary instance] ***************************************************
  1128. skipping: [10.10.10.10]
  1130. TASK [Launch raw postgres on primary] ****************************************************************
  1131. skipping: [10.10.10.10]
  1133. TASK [Launch raw postgres on replicas] ***************************************************************
  1134. skipping: [10.10.10.10]
  1136. TASK [Wait for postgres online] **********************************************************************
  1137. skipping: [10.10.10.10]
  1139. TASK [postgres : Check pgbouncer is installed] *******************************************************
  1140. changed: [10.10.10.10]
  1142. TASK [postgres : Stop existing pgbouncer service] ****************************************************
  1143. ok: [10.10.10.10]
  1145. TASK [postgres : Remove existing pgbouncer dirs] *****************************************************
  1146. changed: [10.10.10.10] => (item=/etc/pgbouncer)
  1147. changed: [10.10.10.10] => (item=/var/log/pgbouncer)
  1148. changed: [10.10.10.10] => (item=/var/run/pgbouncer)
  1150. TASK [Recreate dirs with owner postgres] *************************************************************
  1151. changed: [10.10.10.10] => (item=/etc/pgbouncer)
  1152. changed: [10.10.10.10] => (item=/var/log/pgbouncer)
  1153. changed: [10.10.10.10] => (item=/var/run/pgbouncer)
  1155. TASK [postgres : Copy /etc/pgbouncer/pgbouncer.ini] **************************************************
  1156. changed: [10.10.10.10]
  1158. TASK [postgres : Copy /etc/pgbouncer/pgb_hba.conf] ***************************************************
  1159. changed: [10.10.10.10]
  1161. TASK [postgres : Touch userlist and database list] ***************************************************
  1162. changed: [10.10.10.10] => (item=database.txt)
  1163. changed: [10.10.10.10] => (item=userlist.txt)
  1165. TASK [postgres : Add default users to pgbouncer] *****************************************************
  1166. changed: [10.10.10.10]
  1168. TASK [postgres : Init pgbouncer business database list] **********************************************
  1169. changed: [10.10.10.10] => (item={u'comment': u'pigsty meta database', u'schemas': [u'pigsty'], u'extensions': [{u'name': u'adminpack', u'schema': u'pg_catalog'}, {u'name': u'postgis', u'schema': u'public'}, {u'name': u'timescaledb'}], u'baseline': u'cmdb.sql', u'name': u'meta'})
  1170. changed: [10.10.10.10] => (item={u'owner': u'dbuser_grafana', u'comment': u'grafana primary database', u'name': u'grafana', u'revokeconn': True})
  1171. changed: [10.10.10.10] => (item={u'owner': u'dbuser_bytebase', u'comment': u'bytebase primary database', u'name': u'bytebase', u'revokeconn': True})
  1172. changed: [10.10.10.10] => (item={u'owner': u'dbuser_kong', u'comment': u'kong the api gateway database', u'name': u'kong', u'revokeconn': True})
  1173. changed: [10.10.10.10] => (item={u'owner': u'dbuser_gitea', u'comment': u'gitea meta database', u'name': u'gitea', u'revokeconn': True})
  1175. TASK [postgres : Init pgbouncer business user list] **************************************************
  1176. changed: [10.10.10.10] => (item={u'comment': u'pigsty cmdb admin user', u'roles': [u'dbrole_admin'], u'password': u'DBUser.Meta', u'name': u'dbuser_meta', u'pgbouncer': True})
  1177. changed: [10.10.10.10] => (item={u'comment': u'read-only viewer for meta database', u'roles': [u'dbrole_readonly'], u'password': u'DBUser.Viewer', u'name': u'dbuser_view', u'pgbouncer': True})
  1178. changed: [10.10.10.10] => (item={u'comment': u'admin user for grafana database', u'roles': [u'dbrole_admin'], u'password': u'DBUser.Grafana', u'name': u'dbuser_grafana', u'pgbouncer': True})
  1179. changed: [10.10.10.10] => (item={u'comment': u'admin user for bytebase database', u'roles': [u'dbrole_admin'], u'password': u'DBUser.Bytebase', u'name': u'dbuser_bytebase', u'pgbouncer': True})
  1180. changed: [10.10.10.10] => (item={u'comment': u'admin user for kong api gateway', u'roles': [u'dbrole_admin'], u'password': u'DBUser.Kong', u'name': u'dbuser_kong', u'pgbouncer': True})
  1181. changed: [10.10.10.10] => (item={u'comment': u'admin user for gitea service', u'roles': [u'dbrole_admin'], u'password': u'DBUser.Gitea', u'name': u'dbuser_gitea', u'pgbouncer': True})
  1183. TASK [postgres : Copy pgbouncer systemd service] *****************************************************
  1184. changed: [10.10.10.10]
  1186. TASK [postgres : Launch pgbouncer pool service] ******************************************************
  1187. changed: [10.10.10.10]
  1189. TASK [postgres : Wait for pgbouncer service online] **************************************************
  1190. ok: [10.10.10.10]
  1192. TASK [postgres : Check pgbouncer service is ready] ***************************************************
  1193. changed: [10.10.10.10]
  1195. TASK [postgres : include_tasks] **********************************************************************
  1196. included: /home/vagrant/pigsty/roles/postgres/tasks/createuser.yml for 10.10.10.10
  1197. included: /home/vagrant/pigsty/roles/postgres/tasks/createuser.yml for 10.10.10.10
  1198. included: /home/vagrant/pigsty/roles/postgres/tasks/createuser.yml for 10.10.10.10
  1199. included: /home/vagrant/pigsty/roles/postgres/tasks/createuser.yml for 10.10.10.10
  1200. included: /home/vagrant/pigsty/roles/postgres/tasks/createuser.yml for 10.10.10.10
  1201. included: /home/vagrant/pigsty/roles/postgres/tasks/createuser.yml for 10.10.10.10
  1203. TASK [postgres : Render user dbuser_meta creation sql] ***********************************************
  1204. changed: [10.10.10.10]
  1206. TASK [postgres : Execute user dbuser_meta creation sql on primary] ***********************************
  1207. changed: [10.10.10.10]
  1209. TASK [postgres : Add business user to pgbouncer] *****************************************************
  1210. changed: [10.10.10.10]
  1212. TASK [postgres : Render user dbuser_view creation sql] ***********************************************
  1213. changed: [10.10.10.10]
  1215. TASK [postgres : Execute user dbuser_view creation sql on primary] ***********************************
  1216. changed: [10.10.10.10]
  1218. TASK [postgres : Add business user to pgbouncer] *****************************************************
  1219. changed: [10.10.10.10]
  1221. TASK [postgres : Render user dbuser_grafana creation sql] ********************************************
  1222. changed: [10.10.10.10]
  1224. TASK [postgres : Execute user dbuser_grafana creation sql on primary] ********************************
  1225. changed: [10.10.10.10]
  1227. TASK [postgres : Add business user to pgbouncer] *****************************************************
  1228. changed: [10.10.10.10]
  1230. TASK [postgres : Render user dbuser_bytebase creation sql] *******************************************
  1231. changed: [10.10.10.10]
  1233. TASK [postgres : Execute user dbuser_bytebase creation sql on primary] *******************************
  1234. changed: [10.10.10.10]
  1236. TASK [postgres : Add business user to pgbouncer] *****************************************************
  1237. changed: [10.10.10.10]
  1239. TASK [postgres : Render user dbuser_kong creation sql] ***********************************************
  1240. changed: [10.10.10.10]
  1242. TASK [postgres : Execute user dbuser_kong creation sql on primary] ***********************************
  1243. changed: [10.10.10.10]
  1245. TASK [postgres : Add business user to pgbouncer] *****************************************************
  1246. changed: [10.10.10.10]
  1248. TASK [postgres : Render user dbuser_gitea creation sql] **********************************************
  1249. changed: [10.10.10.10]
  1251. TASK [postgres : Execute user dbuser_gitea creation sql on primary] **********************************
  1252. changed: [10.10.10.10]
  1254. TASK [postgres : Add business user to pgbouncer] *****************************************************
  1255. changed: [10.10.10.10]
  1257. TASK [postgres : include_tasks] **********************************************************************
  1258. included: /home/vagrant/pigsty/roles/postgres/tasks/createdb.yml for 10.10.10.10
  1259. included: /home/vagrant/pigsty/roles/postgres/tasks/createdb.yml for 10.10.10.10
  1260. included: /home/vagrant/pigsty/roles/postgres/tasks/createdb.yml for 10.10.10.10
  1261. included: /home/vagrant/pigsty/roles/postgres/tasks/createdb.yml for 10.10.10.10
  1262. included: /home/vagrant/pigsty/roles/postgres/tasks/createdb.yml for 10.10.10.10
  1264. TASK [postgres : debug] ******************************************************************************
  1265. ok: [10.10.10.10] => {
  1266.     "msg": {
  1267.         "baseline": "cmdb.sql",
  1268.         "comment": "pigsty meta database",
  1269.         "extensions": [
  1270.             {
  1271.                 "name": "adminpack",
  1272.                 "schema": "pg_catalog"
  1273.             },
  1274.             {
  1275.                 "name": "postgis",
  1276.                 "schema": "public"
  1277.             },
  1278.             {
  1279.                 "name": "timescaledb"
  1280.             }
  1281.         ],
  1282.         "name": "meta",
  1283.         "schemas": [
  1284.             "pigsty"
  1285.         ]
  1286.     }
  1287. }
  1289. TASK [postgres : Render database meta creation sql] **************************************************
  1290. changed: [10.10.10.10]
  1292. TASK [postgres : Render database meta baseline sql] **************************************************
  1293. changed: [10.10.10.10]
  1295. TASK [postgres : Execute database meta creation command] *********************************************
  1296. changed: [10.10.10.10]
  1298. TASK [postgres : Execute database meta creation sql] *************************************************
  1299. changed: [10.10.10.10]
  1301. TASK [postgres : Execute database meta baseline sql] *************************************************
  1302. changed: [10.10.10.10]
  1304. TASK [postgres : Add biz database to pgbouncer] ******************************************************
  1305. changed: [10.10.10.10]
  1307. TASK [postgres : debug] ******************************************************************************
  1308. ok: [10.10.10.10] => {
  1309.     "msg": {
  1310.         "comment": "grafana primary database",
  1311.         "name": "grafana",
  1312.         "owner": "dbuser_grafana",
  1313.         "revokeconn": true
  1314.     }
  1315. }
  1317. TASK [postgres : Render database grafana creation sql] ***********************************************
  1318. changed: [10.10.10.10]
  1320. TASK [postgres : Render database grafana baseline sql] ***********************************************
  1321. skipping: [10.10.10.10]
  1323. TASK [postgres : Execute database grafana creation command] ******************************************
  1324. changed: [10.10.10.10]
  1326. TASK [postgres : Execute database grafana creation sql] **********************************************
  1327. changed: [10.10.10.10]
  1329. TASK [postgres : Execute database grafana baseline sql] **********************************************
  1330. skipping: [10.10.10.10]
  1332. TASK [postgres : Add biz database to pgbouncer] ******************************************************
  1333. changed: [10.10.10.10]
  1335. TASK [postgres : debug] ******************************************************************************
  1336. ok: [10.10.10.10] => {
  1337.     "msg": {
  1338.         "comment": "bytebase primary database",
  1339.         "name": "bytebase",
  1340.         "owner": "dbuser_bytebase",
  1341.         "revokeconn": true
  1342.     }
  1343. }
  1345. TASK [postgres : Render database bytebase creation sql] **********************************************
  1346. changed: [10.10.10.10]
  1348. TASK [postgres : Render database bytebase baseline sql] **********************************************
  1349. skipping: [10.10.10.10]
  1351. TASK [postgres : Execute database bytebase creation command] *****************************************
  1352. changed: [10.10.10.10]
  1354. TASK [postgres : Execute database bytebase creation sql] *********************************************
  1355. changed: [10.10.10.10]
  1357. TASK [postgres : Execute database bytebase baseline sql] *********************************************
  1358. skipping: [10.10.10.10]
  1360. TASK [postgres : Add biz database to pgbouncer] ******************************************************
  1361. changed: [10.10.10.10]
  1363. TASK [postgres : debug] ******************************************************************************
  1364. ok: [10.10.10.10] => {
  1365.     "msg": {
  1366.         "comment": "kong the api gateway database",
  1367.         "name": "kong",
  1368.         "owner": "dbuser_kong",
  1369.         "revokeconn": true
  1370.     }
  1371. }
  1373. TASK [postgres : Render database kong creation sql] **************************************************
  1374. changed: [10.10.10.10]
  1376. TASK [postgres : Render database kong baseline sql] **************************************************
  1377. skipping: [10.10.10.10]
  1379. TASK [postgres : Execute database kong creation command] *********************************************
  1380. changed: [10.10.10.10]
  1382. TASK [postgres : Execute database kong creation sql] *************************************************
  1383. changed: [10.10.10.10]
  1385. TASK [postgres : Execute database kong baseline sql] *************************************************
  1386. skipping: [10.10.10.10]
  1388. TASK [postgres : Add biz database to pgbouncer] ******************************************************
  1389. changed: [10.10.10.10]
  1391. TASK [postgres : debug] ******************************************************************************
  1392. ok: [10.10.10.10] => {
  1393.     "msg": {
  1394.         "comment": "gitea meta database",
  1395.         "name": "gitea",
  1396.         "owner": "dbuser_gitea",
  1397.         "revokeconn": true
  1398.     }
  1399. }
  1401. TASK [postgres : Render database gitea creation sql] *************************************************
  1402. changed: [10.10.10.10]
  1404. TASK [postgres : Render database gitea baseline sql] *************************************************
  1405. skipping: [10.10.10.10]
  1407. TASK [postgres : Execute database gitea creation command] ********************************************
  1408. changed: [10.10.10.10]
  1410. TASK [postgres : Execute database gitea creation sql] ************************************************
  1411. changed: [10.10.10.10]
  1413. TASK [postgres : Execute database gitea baseline sql] ************************************************
  1414. skipping: [10.10.10.10]
  1416. TASK [postgres : Add biz database to pgbouncer] ******************************************************
  1417. changed: [10.10.10.10]
  1419. TASK [postgres : Reload pgbouncer to add db and users] ***********************************************
  1420. changed: [10.10.10.10]
  1422. TASK [service : Make sure haproxy is installed] ******************************************************
  1423. ok: [10.10.10.10]
  1425. TASK [service : Create haproxy config directory] *****************************************************
  1426. ok: [10.10.10.10]
  1428. TASK [service : Create haproxy environment file] *****************************************************
  1429. changed: [10.10.10.10]
  1431. TASK [Copy haproxy systemd service file] *************************************************************
  1432. changed: [10.10.10.10]
  1434. TASK [service : Fetch postgres cluster memberships] **************************************************
  1435. ok: [10.10.10.10]
  1437. TASK [service : Templating /etc/haproxy/haproxy.cfg] *************************************************
  1438. changed: [10.10.10.10]
  1440. TASK [service : Reload Haproxy] **********************************************************************
  1441. changed: [10.10.10.10]
  1443. TASK [Launch haproxy load balancer service] **********************************************************
  1444. changed: [10.10.10.10]
  1446. TASK [service : Wait for haproxy load balancer online] ***********************************************
  1447. ok: [10.10.10.10]
  1449. TASK [service : Make sure vip-manager is installed] **************************************************
  1450. ok: [10.10.10.10]
  1452. TASK [Copy vip-manager systemd service file] *********************************************************
  1453. changed: [10.10.10.10]
  1455. TASK [service : create vip-manager systemd drop-in dir] **********************************************
  1456. changed: [10.10.10.10]
  1458. TASK [service : create vip-manager systemd drop-in file] *********************************************
  1459. changed: [10.10.10.10]
  1461. TASK [service : Templating /etc/default/vip-manager.yml] *********************************************
  1462. changed: [10.10.10.10]
  1464. TASK [service : Reload vip-manager config] ***********************************************************
  1465. changed: [10.10.10.10]
  1467. TASK [Add yum repo for pg_exporter] ******************************************************************
  1468. skipping: [10.10.10.10]
  1470. TASK [Install pg_exporter via yum] *******************************************************************
  1471. skipping: [10.10.10.10]
  1473. TASK [Install pg_exporter via binary] ****************************************************************
  1474. skipping: [10.10.10.10]
  1476. TASK [Copy default pg_exporter.yml config] ***********************************************************
  1477. changed: [10.10.10.10]
  1479. TASK [Config pg_exporter parameters] *****************************************************************
  1480. changed: [10.10.10.10]
  1482. TASK [Config pg_exporter systemd unit] ***************************************************************
  1483. changed: [10.10.10.10]
  1485. TASK [pg_exporter : Config pgbouncer_exporter parameters] ********************************************
  1486. changed: [10.10.10.10]
  1488. TASK [pg_exporter : Config pgbouncer_exporter systemd unit] ******************************************
  1489. changed: [10.10.10.10]
  1491. TASK [Launch pg_exporter systemd unit] ***************************************************************
  1492. changed: [10.10.10.10]
  1494. TASK [Wait for pg_exporter online] *******************************************************************
  1495. ok: [10.10.10.10]
  1497. TASK [pg_exporter : Launch pgbouncer_exporter systemd unit] ******************************************
  1498. changed: [10.10.10.10]
  1500. TASK [pg_exporter : Wait for pgbouncer_exporter online] **********************************************
  1501. ok: [10.10.10.10]
  1503. TASK [pg_register : Register postgres service to consul] *********************************************
  1504. changed: [10.10.10.10]
  1506. TASK [pg_register : Register patroni service to consul] **********************************************
  1507. changed: [10.10.10.10]
  1509. TASK [pg_register : Register pgbouncer service to consul] ********************************************
  1510. changed: [10.10.10.10]
  1512. TASK [pg_register : Register pg_exporter service to consul] ******************************************
  1513. changed: [10.10.10.10]
  1515. TASK [pg_register : Register pgbouncer_exporter service to consul] ***********************************
  1516. changed: [10.10.10.10]
  1518. TASK [pg_register : Register haproxy (exporter) service to consul] ***********************************
  1519. changed: [10.10.10.10]
  1521. TASK [pg_register : Register cluster service to consul] **********************************************
  1522. changed: [10.10.10.10] => (item={u'src_ip': u'*', u'check_url': u'/primary', u'src_port': 5433, u'name': u'primary', u'dst_port': u'pgbouncer', u'selector': u'[]'})
  1523. changed: [10.10.10.10] => (item={u'src_ip': u'*', u'check_url': u'/read-only', u'src_port': 5434, u'name': u'replica', u'selector_backup': u'[? pg_role == `primary` || pg_role == `offline` ]', u'dst_port': u'pgbouncer', u'selector': u'[]'})
  1524. changed: [10.10.10.10] => (item={u'haproxy': {u'default_server_options': u'inter 3s fastinter 1s downinter 5s rise 3 fall 3 on-marked-down shutdown-sessions slowstart 30s maxconn 3000 maxqueue 128 weight 100', u'balance': u'roundrobin', u'maxconn': 3000}, u'check_url': u'/primary', u'src_port': 5436, u'name': u'default', u'check_method': u'http', u'selector': u'[]', u'src_ip': u'*', u'dst_port': u'postgres', u'check_code': 200, u'check_port': u'patroni'})
  1525. changed: [10.10.10.10] => (item={u'src_ip': u'*', u'check_url': u'/replica', u'src_port': 5438, u'name': u'offline', u'selector_backup': u'[? pg_role == `replica` && !pg_offline_query]', u'dst_port': u'postgres', u'selector': u'[? pg_role == `offline` || pg_offline_query ]'})
  1527. TASK [pg_register : Reload consul to finish register] ************************************************
  1528. changed: [10.10.10.10]
  1530. TASK [pg_register : Register pgsql exporter as prometheus target] ************************************
  1531. changed: [10.10.10.10 -> 10.10.10.10] => (item=10.10.10.10)
  1533. TASK [pg_register : Render datasource definition on meta node] ***************************************
  1534. changed: [10.10.10.10 -> meta] => (item={u'comment': u'pigsty meta database', u'schemas': [u'pigsty'], u'extensions': [{u'name': u'adminpack', u'schema': u'pg_catalog'}, {u'name': u'postgis', u'schema': u'public'}, {u'name': u'timescaledb'}], u'baseline': u'cmdb.sql', u'name': u'meta'})
  1535. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_grafana', u'comment': u'grafana primary database', u'name': u'grafana', u'revokeconn': True})
  1536. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_bytebase', u'comment': u'bytebase primary database', u'name': u'bytebase', u'revokeconn': True})
  1537. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_kong', u'comment': u'kong the api gateway database', u'name': u'kong', u'revokeconn': True})
  1538. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_gitea', u'comment': u'gitea meta database', u'name': u'gitea', u'revokeconn': True})
  1540. TASK [pg_register : Load grafana datasource on meta node] ********************************************
  1541. changed: [10.10.10.10 -> meta] => (item={u'comment': u'pigsty meta database', u'schemas': [u'pigsty'], u'extensions': [{u'name': u'adminpack', u'schema': u'pg_catalog'}, {u'name': u'postgis', u'schema': u'public'}, {u'name': u'timescaledb'}], u'baseline': u'cmdb.sql', u'name': u'meta'})
  1542. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_grafana', u'comment': u'grafana primary database', u'name': u'grafana', u'revokeconn': True})
  1543. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_bytebase', u'comment': u'bytebase primary database', u'name': u'bytebase', u'revokeconn': True})
  1544. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_kong', u'comment': u'kong the api gateway database', u'name': u'kong', u'revokeconn': True})
  1545. changed: [10.10.10.10 -> meta] => (item={u'owner': u'dbuser_gitea', u'comment': u'gitea meta database', u'name': u'gitea', u'revokeconn': True})
  1547. TASK [pg_register : Create haproxy config dir resource dirs on /etc/pigsty] **************************
  1548. ok: [10.10.10.10 -> 10.10.10.10] => (item=10.10.10.10)
  1550. TASK [pg_register : Register haproxy upstream to nginx] **********************************************
  1551. changed: [10.10.10.10 -> 10.10.10.10] => (item=10.10.10.10)
  1553. TASK [pg_register : Register haproxy url location to nginx] ******************************************
  1554. changed: [10.10.10.10 -> 10.10.10.10] => (item=10.10.10.10)
  1556. TASK [pg_register : Reload nginx to finish haproxy register] *****************************************
  1557. changed: [10.10.10.10 -> 10.10.10.10] => (item=10.10.10.10)
  1559. PLAY RECAP *******************************************************************************************
  1560. 10.10.10.10                : ok=351  changed=266  unreachable=0    failed=0    skipped=80   rescued=0    ignored=0

nodes（可选）

完成单机安装后，使用 nodes.yml 完成 node-1, node-2 , node-3 三个节点的初始化：

nodes.yml

  1. [vagrant@meta pigsty]$ ./nodes.yml -l pg-test
  3. PLAY [Node Identity] *********************************************************************************
  5. TASK [Overwrite node_cluster] ************************************************************************
  6. ok: [10.10.10.12]
  7. ok: [10.10.10.11]
  8. ok: [10.10.10.13]
  10. TASK [Overwrite nodename] ****************************************************************************
  11. ok: [10.10.10.11]
  12. ok: [10.10.10.13]
  13. ok: [10.10.10.12]
  15. TASK [debug] *****************************************************************************************
  16. ok: [10.10.10.11] => {
  17.     "msg": "ins=pg-test-1 cls=pg-test"
  18. }
  19. ok: [10.10.10.13] => {
  20.     "msg": "ins=pg-test-3 cls=pg-test"
  21. }
  22. ok: [10.10.10.12] => {
  23.     "msg": "ins=pg-test-2 cls=pg-test"
  24. }
  26. PLAY [Node Init] *************************************************************************************
  28. TASK [Set hostname from nodename] ********************************************************************
  29. changed: [10.10.10.11]
  30. changed: [10.10.10.12]
  31. changed: [10.10.10.13]
  33. TASK [node : Fetch hostname from server] *************************************************************
  34. skipping: [10.10.10.11]
  35. skipping: [10.10.10.13]
  36. skipping: [10.10.10.12]
  38. TASK [node : Exchange hostname among servers] ********************************************************
  39. skipping: [10.10.10.11]
  40. skipping: [10.10.10.13]
  41. skipping: [10.10.10.12]
  43. TASK [node : Write static dns records to /etc/hosts] *************************************************
  44. changed: [10.10.10.13] => (item=10.10.10.10 meta pigsty p.pigsty g.pigsty a.pigsty c.pigsty l.pigsty)
  45. changed: [10.10.10.12] => (item=10.10.10.10 meta pigsty p.pigsty g.pigsty a.pigsty c.pigsty l.pigsty)
  46. changed: [10.10.10.11] => (item=10.10.10.10 meta pigsty p.pigsty g.pigsty a.pigsty c.pigsty l.pigsty)
  47. changed: [10.10.10.12] => (item=10.10.10.10 api.pigsty adm.pigsty cli.pigsty ddl.pigsty lab.pigsty git.pigsty sss.pigsty)
  48. changed: [10.10.10.11] => (item=10.10.10.10 api.pigsty adm.pigsty cli.pigsty ddl.pigsty lab.pigsty git.pigsty sss.pigsty)
  49. changed: [10.10.10.13] => (item=10.10.10.10 api.pigsty adm.pigsty cli.pigsty ddl.pigsty lab.pigsty git.pigsty sss.pigsty)
  51. TASK [node : Write extra static dns records to /etc/hosts] *******************************************
  53. TASK [node : Get old nameservers] ********************************************************************
  54. changed: [10.10.10.11]
  55. changed: [10.10.10.13]
  56. changed: [10.10.10.12]
  58. TASK [node : Write tmp resolv file] ******************************************************************
  59. changed: [10.10.10.11]
  60. changed: [10.10.10.12]
  61. changed: [10.10.10.13]
  63. TASK [node : Write resolv options] *******************************************************************
  64. changed: [10.10.10.13] => (item=options single-request-reopen timeout:1 rotate)
  65. changed: [10.10.10.11] => (item=options single-request-reopen timeout:1 rotate)
  66. changed: [10.10.10.12] => (item=options single-request-reopen timeout:1 rotate)
  67. changed: [10.10.10.13] => (item=domain service.consul)
  68. changed: [10.10.10.11] => (item=domain service.consul)
  69. changed: [10.10.10.12] => (item=domain service.consul)
  71. TASK [node : Write additional nameservers] ***********************************************************
  72. changed: [10.10.10.13] => (item=10.10.10.10)
  73. changed: [10.10.10.11] => (item=10.10.10.10)
  74. changed: [10.10.10.12] => (item=10.10.10.10)
  76. TASK [node : Append existing nameservers] ************************************************************
  77. changed: [10.10.10.11] => (item=10.0.2.3)
  78. changed: [10.10.10.13] => (item=10.0.2.3)
  79. changed: [10.10.10.12] => (item=10.0.2.3)
  81. TASK [node : Swap resolv.conf] ***********************************************************************
  82. changed: [10.10.10.11]
  83. changed: [10.10.10.13]
  84. changed: [10.10.10.12]
  86. TASK [node : Node configure disable firewall] ********************************************************
  87. ok: [10.10.10.12]
  88. ok: [10.10.10.11]
  89. ok: [10.10.10.13]
  91. TASK [node : Node disable selinux by default] ********************************************************
  92. [WARNING]: SELinux state temporarily changed from 'enforcing' to 'permissive'. State change will take
  93. effect next reboot.
  94. changed: [10.10.10.11]
  95. changed: [10.10.10.13]
  96. changed: [10.10.10.12]
  98. TASK [node : Backup existing repos] ******************************************************************
  99. changed: [10.10.10.11]
  100. changed: [10.10.10.13]
  101. changed: [10.10.10.12]
  103. TASK [node : Install upstream repo] ******************************************************************
  104. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Base', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/os/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/os/$basearch/', u'http://mirror.centos.org/centos/$releasever/os/$basearch/'], u'name': u'base'})
  105. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Updates', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/updates/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/updates/$basearch/', u'http://mirror.centos.org/centos/$releasever/updates/$basearch/'], u'name': u'updates'})
  106. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Extras', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/extras/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/extras/$basearch/', u'http://mirror.centos.org/centos/$releasever/extras/$basearch/'], u'name': u'extras'})
  107. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Base', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/os/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/os/$basearch/', u'http://mirror.centos.org/centos/$releasever/os/$basearch/'], u'name': u'base'})
  108. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Updates', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/updates/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/updates/$basearch/', u'http://mirror.centos.org/centos/$releasever/updates/$basearch/'], u'name': u'updates'})
  109. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Extras', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/extras/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/extras/$basearch/', u'http://mirror.centos.org/centos/$releasever/extras/$basearch/'], u'name': u'extras'})
  110. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'CentOS $releasever - epel', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/epel/$releasever/$basearch', u'http://mirrors.aliyun.com/epel/$releasever/$basearch', u'http://download.fedoraproject.org/pub/epel/$releasever/$basearch'], u'name': u'epel'})
  111. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'CentOS $releasever - epel', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/epel/$releasever/$basearch', u'http://mirrors.aliyun.com/epel/$releasever/$basearch', u'http://download.fedoraproject.org/pub/epel/$releasever/$basearch'], u'name': u'epel'})
  112. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'enabled': True, u'description': u'Grafana', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/grafana/yum/rpm', u'https://packages.grafana.com/oss/rpm'], u'name': u'grafana'})
  113. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'enabled': True, u'description': u'Grafana', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/grafana/yum/rpm', u'https://packages.grafana.com/oss/rpm'], u'name': u'grafana'})
  114. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'Prometheus and exporters', u'baseurl': u'https://packagecloud.io/prometheus-rpm/release/el/$releasever/$basearch', u'name': u'prometheus'})
  115. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'PostgreSQL common RPMs for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'http://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/common/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg-common'})
  116. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'Prometheus and exporters', u'baseurl': u'https://packagecloud.io/prometheus-rpm/release/el/$releasever/$basearch', u'name': u'prometheus'})
  117. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Base', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/os/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/os/$basearch/', u'http://mirror.centos.org/centos/$releasever/os/$basearch/'], u'name': u'base'})
  118. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Updates', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/updates/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/updates/$basearch/', u'http://mirror.centos.org/centos/$releasever/updates/$basearch/'], u'name': u'updates'})
  119. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'PostgreSQL 14 for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/14/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg14'})
  120. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - Extras', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/extras/$basearch/', u'http://mirrors.aliyun.com/centos/$releasever/extras/$basearch/', u'http://mirror.centos.org/centos/$releasever/extras/$basearch/'], u'name': u'extras'})
  121. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'PostgreSQL common RPMs for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'http://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/common/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg-common'})
  122. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'TimescaleDB for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://packagecloud.io/timescale/timescaledb/el/7/$basearch'], u'name': u'timescaledb'})
  123. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'CentOS $releasever - epel', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/epel/$releasever/$basearch', u'http://mirrors.aliyun.com/epel/$releasever/$basearch', u'http://download.fedoraproject.org/pub/epel/$releasever/$basearch'], u'name': u'epel'})
  124. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/sclo/', u'name': u'centos-sclo'})
  125. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'PostgreSQL 14 for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/14/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg14'})
  126. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo rh', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/rh/', u'name': u'centos-sclo-rh'})
  127. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'enabled': True, u'description': u'Grafana', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/grafana/yum/rpm', u'https://packages.grafana.com/oss/rpm'], u'name': u'grafana'})
  128. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'TimescaleDB for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://packagecloud.io/timescale/timescaledb/el/7/$basearch'], u'name': u'timescaledb'})
  129. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'nginx', u'baseurl': u'http://nginx.org/packages/centos/$releasever/$basearch/', u'description': u'Nginx Official Yum Repo'})
  130. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'harbottle', u'baseurl': u'https://download.copr.fedorainfracloud.org/results/harbottle/main/epel-$releasever-$basearch/', u'description': u'Copr repo for main owned by harbottle'})
  131. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'Prometheus and exporters', u'baseurl': u'https://packagecloud.io/prometheus-rpm/release/el/$releasever/$basearch', u'name': u'prometheus'})
  132. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/sclo/', u'name': u'centos-sclo'})
  133. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'pg_probackup', u'baseurl': u'https://repo.postgrespro.ru/pg_probackup-forks/rpm/latest/centos-$releasever-$basearch', u'description': u'PG_PROBACKUP Centos packages for PostgresPro Standard and Enterprise - $basearch'})
  134. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'PostgreSQL common RPMs for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'http://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/common/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg-common'})
  135. skipping: [10.10.10.13] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'docker-ce', u'baseurl': [u'https://mirrors.aliyun.com/docker-ce/linux/centos/$releasever/$basearch/stable', u'https://download.docker.com/linux/centos/$releasever/$basearch/stable'], u'description': u'Docker CE Stable - $basearch'})
  136. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo rh', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/rh/', u'name': u'centos-sclo-rh'})
  137. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'PostgreSQL 14 for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/yum/14/redhat/rhel-$releasever-$basearch', u'https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-$releasever-$basearch'], u'name': u'pgdg14'})
  138. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'nginx', u'baseurl': u'http://nginx.org/packages/centos/$releasever/$basearch/', u'description': u'Nginx Official Yum Repo'})
  139. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'TimescaleDB for RHEL/CentOS $releasever - $basearch', u'baseurl': [u'https://packagecloud.io/timescale/timescaledb/el/7/$basearch'], u'name': u'timescaledb'})
  140. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'harbottle', u'baseurl': u'https://download.copr.fedorainfracloud.org/results/harbottle/main/epel-$releasever-$basearch/', u'description': u'Copr repo for main owned by harbottle'})
  141. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/sclo/', u'name': u'centos-sclo'})
  142. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'pg_probackup', u'baseurl': u'https://repo.postgrespro.ru/pg_probackup-forks/rpm/latest/centos-$releasever-$basearch', u'description': u'PG_PROBACKUP Centos packages for PostgresPro Standard and Enterprise - $basearch'})
  143. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'description': u'CentOS-$releasever - SCLo rh', u'baseurl': u'http://mirrors.aliyun.com/centos/$releasever/sclo/$basearch/rh/', u'name': u'centos-sclo-rh'})
  144. skipping: [10.10.10.11] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'docker-ce', u'baseurl': [u'https://mirrors.aliyun.com/docker-ce/linux/centos/$releasever/$basearch/stable', u'https://download.docker.com/linux/centos/$releasever/$basearch/stable'], u'description': u'Docker CE Stable - $basearch'})
  145. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'nginx', u'baseurl': u'http://nginx.org/packages/centos/$releasever/$basearch/', u'description': u'Nginx Official Yum Repo'})
  146. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'harbottle', u'baseurl': u'https://download.copr.fedorainfracloud.org/results/harbottle/main/epel-$releasever-$basearch/', u'description': u'Copr repo for main owned by harbottle'})
  147. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'pg_probackup', u'baseurl': u'https://repo.postgrespro.ru/pg_probackup-forks/rpm/latest/centos-$releasever-$basearch', u'description': u'PG_PROBACKUP Centos packages for PostgresPro Standard and Enterprise - $basearch'})
  148. skipping: [10.10.10.12] => (item={u'gpgcheck': False, u'skip_if_unavailable': True, u'name': u'docker-ce', u'baseurl': [u'https://mirrors.aliyun.com/docker-ce/linux/centos/$releasever/$basearch/stable', u'https://download.docker.com/linux/centos/$releasever/$basearch/stable'], u'description': u'Docker CE Stable - $basearch'})
  150. TASK [node : Install local repo] *********************************************************************
  151. changed: [10.10.10.12] => (item=http://pigsty/pigsty.repo)
  152. changed: [10.10.10.11] => (item=http://pigsty/pigsty.repo)
  153. changed: [10.10.10.13] => (item=http://pigsty/pigsty.repo)
  155. TASK [Install node basic packages] *******************************************************************
  156. skipping: [10.10.10.11] => (item=[])
  157. skipping: [10.10.10.13] => (item=[])
  158. skipping: [10.10.10.12] => (item=[])
  160. TASK [Install node extra packages] *******************************************************************
  162. TASK [node : Install meta specific packages] *********************************************************
  163. skipping: [10.10.10.11] => (item=[])
  164. skipping: [10.10.10.13] => (item=[])
  165. skipping: [10.10.10.12] => (item=[])
  167. TASK [Install node basic packages] *******************************************************************
  168. changed: [10.10.10.11] => (item=[u'wget,sshpass,ntp,chrony,tuned,uuid,lz4,make,patch,bash,lsof,wget,unzip,git,ftp,vim-minimal,ca-certificates', u'numactl,grubby,sysstat,dstat,iotop,bind-utils,net-tools,tcpdump,socat,ipvsadm,telnet,tuned,nc,pv,jq,perf', u'readline,zlib,openssl,openssl-libs,openssh-clients,python3,python36-requests,node_exporter,consul,etcd,promtail'])
  169. changed: [10.10.10.12] => (item=[u'wget,sshpass,ntp,chrony,tuned,uuid,lz4,make,patch,bash,lsof,wget,unzip,git,ftp,vim-minimal,ca-certificates', u'numactl,grubby,sysstat,dstat,iotop,bind-utils,net-tools,tcpdump,socat,ipvsadm,telnet,tuned,nc,pv,jq,perf', u'readline,zlib,openssl,openssl-libs,openssh-clients,python3,python36-requests,node_exporter,consul,etcd,promtail'])
  170. changed: [10.10.10.13] => (item=[u'wget,sshpass,ntp,chrony,tuned,uuid,lz4,make,patch,bash,lsof,wget,unzip,git,ftp,vim-minimal,ca-certificates', u'numactl,grubby,sysstat,dstat,iotop,bind-utils,net-tools,tcpdump,socat,ipvsadm,telnet,tuned,nc,pv,jq,perf', u'readline,zlib,openssl,openssl-libs,openssh-clients,python3,python36-requests,node_exporter,consul,etcd,promtail'])
  172. TASK [Install node extra packages] *******************************************************************
  174. TASK [node : Install meta specific packages] *********************************************************
  175. skipping: [10.10.10.11] => (item=[])
  176. skipping: [10.10.10.13] => (item=[])
  177. skipping: [10.10.10.12] => (item=[])
  179. TASK [Install pip3 packages on meta node] ************************************************************
  180. skipping: [10.10.10.11]
  181. skipping: [10.10.10.13]
  182. skipping: [10.10.10.12]
  184. TASK [node : Node configure disable numa] ************************************************************
  185. skipping: [10.10.10.11]
  186. skipping: [10.10.10.13]
  187. skipping: [10.10.10.12]
  189. TASK [node : Node configure disable swap] ************************************************************
  190. skipping: [10.10.10.11]
  191. skipping: [10.10.10.13]
  192. skipping: [10.10.10.12]
  194. TASK [node : Node configure unmount swap] ************************************************************
  195. skipping: [10.10.10.11] => (item=swap)
  196. skipping: [10.10.10.11] => (item=none)
  197. skipping: [10.10.10.13] => (item=swap)
  198. skipping: [10.10.10.12] => (item=swap)
  199. skipping: [10.10.10.12] => (item=none)
  200. skipping: [10.10.10.13] => (item=none)
  202. TASK [node : Node setup static network] **************************************************************
  203. changed: [10.10.10.11]
  204. changed: [10.10.10.13]
  205. changed: [10.10.10.12]
  207. TASK [node : Node configure disable firewall] ********************************************************
  208. changed: [10.10.10.11]
  209. changed: [10.10.10.13]
  210. changed: [10.10.10.12]
  212. TASK [node : Node configure disk prefetch] ***********************************************************
  213. skipping: [10.10.10.11]
  214. skipping: [10.10.10.13]
  215. skipping: [10.10.10.12]
  217. TASK [node : Enable linux kernel modules] ************************************************************
  218. changed: [10.10.10.11] => (item=softdog)
  219. changed: [10.10.10.12] => (item=softdog)
  220. changed: [10.10.10.13] => (item=softdog)
  221. changed: [10.10.10.11] => (item=br_netfilter)
  222. changed: [10.10.10.13] => (item=br_netfilter)
  223. changed: [10.10.10.12] => (item=br_netfilter)
  224. changed: [10.10.10.11] => (item=ip_vs)
  225. changed: [10.10.10.13] => (item=ip_vs)
  226. changed: [10.10.10.12] => (item=ip_vs)
  227. changed: [10.10.10.13] => (item=ip_vs_rr)
  228. changed: [10.10.10.11] => (item=ip_vs_rr)
  229. changed: [10.10.10.12] => (item=ip_vs_rr)
  230. ok: [10.10.10.13] => (item=ip_vs_rr)
  231. ok: [10.10.10.11] => (item=ip_vs_rr)
  232. ok: [10.10.10.12] => (item=ip_vs_rr)
  233. changed: [10.10.10.13] => (item=ip_vs_wrr)
  234. changed: [10.10.10.11] => (item=ip_vs_wrr)
  235. changed: [10.10.10.12] => (item=ip_vs_wrr)
  236. changed: [10.10.10.13] => (item=ip_vs_sh)
  237. changed: [10.10.10.11] => (item=ip_vs_sh)
  238. changed: [10.10.10.12] => (item=ip_vs_sh)
  240. TASK [node : Enable kernel module on reboot] *********************************************************
  241. changed: [10.10.10.11]
  242. changed: [10.10.10.12]
  243. changed: [10.10.10.13]
  245. TASK [node : Get config parameter page count] ********************************************************
  246. changed: [10.10.10.11]
  247. changed: [10.10.10.13]
  248. changed: [10.10.10.12]
  250. TASK [node : Get config parameter page size] *********************************************************
  251. changed: [10.10.10.11]
  252. changed: [10.10.10.12]
  253. changed: [10.10.10.13]
  255. TASK [node : Tune shmmax and shmall via mem] *********************************************************
  256. skipping: [10.10.10.11]
  257. skipping: [10.10.10.13]
  258. skipping: [10.10.10.12]
  260. TASK [node : Create tuned profiles] ******************************************************************
  261. changed: [10.10.10.12] => (item=oltp)
  262. changed: [10.10.10.13] => (item=oltp)
  263. changed: [10.10.10.11] => (item=oltp)
  264. changed: [10.10.10.12] => (item=olap)
  265. changed: [10.10.10.13] => (item=olap)
  266. changed: [10.10.10.11] => (item=olap)
  267. changed: [10.10.10.13] => (item=crit)
  268. changed: [10.10.10.11] => (item=crit)
  269. changed: [10.10.10.12] => (item=crit)
  270. changed: [10.10.10.13] => (item=tiny)
  271. changed: [10.10.10.12] => (item=tiny)
  272. changed: [10.10.10.11] => (item=tiny)
  274. TASK [node : Render tuned profiles] ******************************************************************
  275. changed: [10.10.10.11] => (item=oltp)
  276. changed: [10.10.10.12] => (item=oltp)
  277. changed: [10.10.10.13] => (item=oltp)
  278. changed: [10.10.10.13] => (item=olap)
  279. changed: [10.10.10.11] => (item=olap)
  280. changed: [10.10.10.12] => (item=olap)
  281. changed: [10.10.10.13] => (item=crit)
  282. changed: [10.10.10.11] => (item=crit)
  283. changed: [10.10.10.12] => (item=crit)
  284. changed: [10.10.10.11] => (item=tiny)
  285. changed: [10.10.10.12] => (item=tiny)
  286. changed: [10.10.10.13] => (item=tiny)
  288. TASK [node : Active tuned profile] *******************************************************************
  289. changed: [10.10.10.12]
  290. changed: [10.10.10.11]
  291. changed: [10.10.10.13]
  293. TASK [node : Change additional sysctl params] ********************************************************
  295. TASK [node : Copy default user bash profile] *********************************************************
  296. changed: [10.10.10.11]
  297. changed: [10.10.10.13]
  298. changed: [10.10.10.12]
  300. TASK [Setup node default pam ulimits] ****************************************************************
  301. changed: [10.10.10.11]
  302. changed: [10.10.10.13]
  303. changed: [10.10.10.12]
  305. TASK [Create node data dir if exists] ****************************************************************
  306. changed: [10.10.10.13]
  307. changed: [10.10.10.12]
  308. changed: [10.10.10.11]
  310. TASK [node : Create os user group admin] *************************************************************
  311. changed: [10.10.10.11]
  312. changed: [10.10.10.12]
  313. changed: [10.10.10.13]
  315. TASK [node : Create os user admin] *******************************************************************
  316. changed: [10.10.10.11]
  317. changed: [10.10.10.13]
  318. changed: [10.10.10.12]
  320. TASK [node : Grant admin group nopass sudo] **********************************************************
  321. changed: [10.10.10.11]
  322. changed: [10.10.10.12]
  323. changed: [10.10.10.13]
  325. TASK [node : Add no host checking to ssh config] *****************************************************
  326. changed: [10.10.10.12]
  327. changed: [10.10.10.11]
  328. changed: [10.10.10.13]
  330. TASK [node : Add admin ssh no host checking] *********************************************************
  331. ok: [10.10.10.11]
  332. ok: [10.10.10.13]
  333. ok: [10.10.10.12]
  335. TASK [node : Fetch all admin public keys] ************************************************************
  336. changed: [10.10.10.11]
  337. changed: [10.10.10.13]
  338. changed: [10.10.10.12]
  340. TASK [node : Exchange all admin ssh keys] ************************************************************
  341. changed: [10.10.10.11 -> 10.10.10.11] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDkTNwjSFHA06ZaMe+iQz0TRfKAEFqFYpynY/j39VsZyF1D0Yb5tmjxKQTbPM8BTvaFf8WHb5cgdnCkXe3h5JcBPRDWyyKiK7N/reCLwFGilPB1jMlvAS5FoRSlafcyz4GgoYUoB8qQ9Q9QXYpOFnHVWzpbB1zUo57DZbcSgy4BLVl6bwnotJPfI/5vPrq8u/DFYMkmJC3d/XSQUTlkcf1PW4HkJGT/MS8KLkVAbmVIwyubXKxPqb+f2cKAUemXrdTlMms+kKwkqGAMoCejTFojqziLbh+QRUOCGsZfT74U5hHzFYuaRIV+F+HEpWulskY1M2eVrMyT0Ybu9v7RQL6T ansible-generated on pg-test-1', u'10.10.10.11'])
  342. changed: [10.10.10.13 -> 10.10.10.11] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC+JPJizHg8wpC71Qz930m7cOaALWXl/QfdCnccy19/xBVBkgLCe9zkUKtopNaRLzhiPKrchcq5bCHZhCqQH4tOwsM1QpXU8yWbILv3yOuxAtFD9Uvor7XJubb8COqWCnoE3zp3AOtD1I+PA5ukanyW4mQKsIOVZBkSxkN2J2BYhMiIQ27VpM9ecLXx0JKCwLWBx3Z0X96QL6D5pw13nMctZ81FvIopmzu6ZGcNm0tAKd/0lzKJA+jfAuxhxvfPhAO8QhH6s9OnYbfKTS1ttYhIN2qvurFeLjxebNMe01YujZb43vpErKm8F7X7Mr2IFqjwnXKuyB2aP12iNhJbGf4l ansible-generated on pg-test-3', u'10.10.10.11'])
  343. changed: [10.10.10.12 -> 10.10.10.11] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDedbpfcV5RWRXfZEApOTRBkdOqZtlAKcsLAdoOg+cvnRrXeOWhUpuga6WF4CMTEafJKB1HZL4WUW7bzX4YMIFC4FO+LaqV+Q+hrEbCQ44R6MKfuLncPutVZjrp0zr0v5zfX78qR9Qd/Sg6bRNQGICBM2BrH0z7ws6WPbzFUrTeOo+O6+JeKY+Tei9OydyZF/GooYsbU4X/sFE6bfdhyxjeiHR7o8zBM3LsCiFv1L6+lJK83Z7pqHwS/rQonO0nQDKbmsFL5in5fT4Hsw11NbTCUUTO2W/6qzCzlK3WwJFMr5GNi0D9f85ES1kqJlHyacMHGhYkq/AXDNIkTai+MnVl ansible-generated on pg-test-2', u'10.10.10.11'])
  344. changed: [10.10.10.11 -> 10.10.10.13] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDkTNwjSFHA06ZaMe+iQz0TRfKAEFqFYpynY/j39VsZyF1D0Yb5tmjxKQTbPM8BTvaFf8WHb5cgdnCkXe3h5JcBPRDWyyKiK7N/reCLwFGilPB1jMlvAS5FoRSlafcyz4GgoYUoB8qQ9Q9QXYpOFnHVWzpbB1zUo57DZbcSgy4BLVl6bwnotJPfI/5vPrq8u/DFYMkmJC3d/XSQUTlkcf1PW4HkJGT/MS8KLkVAbmVIwyubXKxPqb+f2cKAUemXrdTlMms+kKwkqGAMoCejTFojqziLbh+QRUOCGsZfT74U5hHzFYuaRIV+F+HEpWulskY1M2eVrMyT0Ybu9v7RQL6T ansible-generated on pg-test-1', u'10.10.10.13'])
  345. changed: [10.10.10.13 -> 10.10.10.13] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC+JPJizHg8wpC71Qz930m7cOaALWXl/QfdCnccy19/xBVBkgLCe9zkUKtopNaRLzhiPKrchcq5bCHZhCqQH4tOwsM1QpXU8yWbILv3yOuxAtFD9Uvor7XJubb8COqWCnoE3zp3AOtD1I+PA5ukanyW4mQKsIOVZBkSxkN2J2BYhMiIQ27VpM9ecLXx0JKCwLWBx3Z0X96QL6D5pw13nMctZ81FvIopmzu6ZGcNm0tAKd/0lzKJA+jfAuxhxvfPhAO8QhH6s9OnYbfKTS1ttYhIN2qvurFeLjxebNMe01YujZb43vpErKm8F7X7Mr2IFqjwnXKuyB2aP12iNhJbGf4l ansible-generated on pg-test-3', u'10.10.10.13'])
  346. changed: [10.10.10.12 -> 10.10.10.13] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDedbpfcV5RWRXfZEApOTRBkdOqZtlAKcsLAdoOg+cvnRrXeOWhUpuga6WF4CMTEafJKB1HZL4WUW7bzX4YMIFC4FO+LaqV+Q+hrEbCQ44R6MKfuLncPutVZjrp0zr0v5zfX78qR9Qd/Sg6bRNQGICBM2BrH0z7ws6WPbzFUrTeOo+O6+JeKY+Tei9OydyZF/GooYsbU4X/sFE6bfdhyxjeiHR7o8zBM3LsCiFv1L6+lJK83Z7pqHwS/rQonO0nQDKbmsFL5in5fT4Hsw11NbTCUUTO2W/6qzCzlK3WwJFMr5GNi0D9f85ES1kqJlHyacMHGhYkq/AXDNIkTai+MnVl ansible-generated on pg-test-2', u'10.10.10.13'])
  347. changed: [10.10.10.11 -> 10.10.10.12] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDkTNwjSFHA06ZaMe+iQz0TRfKAEFqFYpynY/j39VsZyF1D0Yb5tmjxKQTbPM8BTvaFf8WHb5cgdnCkXe3h5JcBPRDWyyKiK7N/reCLwFGilPB1jMlvAS5FoRSlafcyz4GgoYUoB8qQ9Q9QXYpOFnHVWzpbB1zUo57DZbcSgy4BLVl6bwnotJPfI/5vPrq8u/DFYMkmJC3d/XSQUTlkcf1PW4HkJGT/MS8KLkVAbmVIwyubXKxPqb+f2cKAUemXrdTlMms+kKwkqGAMoCejTFojqziLbh+QRUOCGsZfT74U5hHzFYuaRIV+F+HEpWulskY1M2eVrMyT0Ybu9v7RQL6T ansible-generated on pg-test-1', u'10.10.10.12'])
  348. changed: [10.10.10.13 -> 10.10.10.12] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC+JPJizHg8wpC71Qz930m7cOaALWXl/QfdCnccy19/xBVBkgLCe9zkUKtopNaRLzhiPKrchcq5bCHZhCqQH4tOwsM1QpXU8yWbILv3yOuxAtFD9Uvor7XJubb8COqWCnoE3zp3AOtD1I+PA5ukanyW4mQKsIOVZBkSxkN2J2BYhMiIQ27VpM9ecLXx0JKCwLWBx3Z0X96QL6D5pw13nMctZ81FvIopmzu6ZGcNm0tAKd/0lzKJA+jfAuxhxvfPhAO8QhH6s9OnYbfKTS1ttYhIN2qvurFeLjxebNMe01YujZb43vpErKm8F7X7Mr2IFqjwnXKuyB2aP12iNhJbGf4l ansible-generated on pg-test-3', u'10.10.10.12'])
  349. changed: [10.10.10.12 -> 10.10.10.12] => (item=[u'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDedbpfcV5RWRXfZEApOTRBkdOqZtlAKcsLAdoOg+cvnRrXeOWhUpuga6WF4CMTEafJKB1HZL4WUW7bzX4YMIFC4FO+LaqV+Q+hrEbCQ44R6MKfuLncPutVZjrp0zr0v5zfX78qR9Qd/Sg6bRNQGICBM2BrH0z7ws6WPbzFUrTeOo+O6+JeKY+Tei9OydyZF/GooYsbU4X/sFE6bfdhyxjeiHR7o8zBM3LsCiFv1L6+lJK83Z7pqHwS/rQonO0nQDKbmsFL5in5fT4Hsw11NbTCUUTO2W/6qzCzlK3WwJFMr5GNi0D9f85ES1kqJlHyacMHGhYkq/AXDNIkTai+MnVl ansible-generated on pg-test-2', u'10.10.10.12'])
  351. TASK [node : Install public keys] ********************************************************************
  352. changed: [10.10.10.13] => (item=ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAAAgQC7IMAMNavYtWwzAJajKqwdn3ar5BhvcwCnBTxxEkXhGlCO2vfgosSAQMEflfgvkiI5nM1HIFQ8KINlx1XLO7SdL5KdInG5LIJjAFh0pujS4kNCT9a5IGvSq1BrzGqhbEcwWYdju1ZPYBcJm/MG+JD0dYCh8vfrYB/cYMD0SOmNkQ== vagrant@pigsty.com)
  353. changed: [10.10.10.11] => (item=ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAAAgQC7IMAMNavYtWwzAJajKqwdn3ar5BhvcwCnBTxxEkXhGlCO2vfgosSAQMEflfgvkiI5nM1HIFQ8KINlx1XLO7SdL5KdInG5LIJjAFh0pujS4kNCT9a5IGvSq1BrzGqhbEcwWYdju1ZPYBcJm/MG+JD0dYCh8vfrYB/cYMD0SOmNkQ== vagrant@pigsty.com)
  354. changed: [10.10.10.12] => (item=ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAAAgQC7IMAMNavYtWwzAJajKqwdn3ar5BhvcwCnBTxxEkXhGlCO2vfgosSAQMEflfgvkiI5nM1HIFQ8KINlx1XLO7SdL5KdInG5LIJjAFh0pujS4kNCT9a5IGvSq1BrzGqhbEcwWYdju1ZPYBcJm/MG+JD0dYCh8vfrYB/cYMD0SOmNkQ== vagrant@pigsty.com)
  356. TASK [node : Install current public key] *************************************************************
  357. ok: [10.10.10.11]
  358. ok: [10.10.10.12]
  359. ok: [10.10.10.13]
  361. TASK [Setup default node timezone] *******************************************************************
  362. changed: [10.10.10.12]
  363. changed: [10.10.10.11]

pgsql（可选）

完成节点初始化后，使用 pgsql.yml 完成 pg-test 数据库集群的初始化：

nodes.yml

redis（可选）

您还可以使用 redis.yml 完成 Redis 数据库集群的初始化：

redis.yml

Last modified 2022-06-20: add timescaledb (3c335f4)