PostgreSQL高可用patroni （02-etcd信息查看）

pg集群状态信息：

[root@hecs-66a2 ~]# patronictl -c /tmp/p1.yml list
+-------------+----------------+---------+---------+----+-----------+--------------------------+
| Member      | Host           | Role    | State   | TL | Lag in MB | Tags                     |
+ Cluster: batman (7029205887923261839) -+---------+----+-----------+--------------------------+
| postgresql0 | 127.0.0.1:5432 | Leader  | running |  1 |           |                          |
| postgresql1 | 127.0.0.1:5433 | Replica | running |  1 |         0 |                          |
| postgresql2 | 127.0.0.1:5434 | Replica | running |  1 |         0 | replicatefrom: postgres1 |
+-------------+----------------+---------+---------+----+-----------+--------------------------+

etcdctl 显示所有存储的key信息

[root@hecs-66a2 ~]# etcdctl  ls --recursive /
/service
/service/batman
/service/batman/config
/service/batman/leader
/service/batman/status
/service/batman/members
/service/batman/members/postgresql0
/service/batman/members/postgresql1
/service/batman/members/postgresql2
/service/batman/initialize

查询集群的leader

[root@hecs-66a2 ~]# etcdctl get /service/batman/leader
postgresql0

查询数据库节点信息：

[root@hecs-66a2 ~]# etcdctl get /service/batman/members/postgresql0
{"conn_url":"postgres://127.0.0.1:5432/postgres","api_url":"http://127.0.0.1:8008/patroni","state":"running","role":"master","version":"2.1.1","xlog_location":83886408,"timeline":1}
[root@hecs-66a2 ~]# etcdctl get /service/batman/members/postgresql1
{"conn_url":"postgres://127.0.0.1:5433/postgres","api_url":"http://127.0.0.1:8009/patroni","state":"running","role":"replica","version":"2.1.1","xlog_location":83886408,"timeline":1}]
[root@hecs-66a2 ~]# etcdctl get /service/batman/members/postgresql2
{"conn_url":"postgres://127.0.0.1:5434/postgres","api_url":"http://127.0.0.1:8010/patroni","state":"running","role":"replica","version":"2.1.1","tags":{"replicatefrom":"postgres1"},"xlog_location":83886408,"timeline":1}

查询配置信息：

[root@hecs-66a2 ~]# etcdctl get /service/batman/config
{"ttl":30,"loop_wait":10,"retry_timeout":10,"maximum_lag_on_failover":1048576,"postgresql":{"use_pg_rewind":true,"parameters":null}}