官术网_书友最值得收藏!

Streamlining wal_level and monitoring

The wal_level setting has always been a bit hard to understand for many people. Many were struggling with the difference between the archive and hot_standby settings. To remove this confusion altogether, both settings have been replaced with the easier-to-understand replica setting, which does the same as hot_standby.

In addition to that, the monitoring of replicated setups has been simplified. Prior to 9.6, there was only the pg_stat_replication view, which could be queried on the master to supervise the flow of data to the slave. Now it is also possible to monitor the flow of data on the slaves, by consulting the pg_stat_wal_receiver function. It is basically the slave-side mirror of the pg_stat_replication function and helps to determine the state of replication.

主站蜘蛛池模板: 荔波县| 井冈山市| 镇赉县| 邯郸市| 青州市| 辽宁省| 渑池县| 天峨县| 永济市| 亳州市| 富阳市| 吉水县| 云和县| 西充县| 广汉市| 泰兴市| 灯塔市| 施甸县| 黎川县| 永嘉县| 焉耆| 合阳县| 保德县| 城固县| 灵璧县| 西乌珠穆沁旗| 邳州市| 西和县| 武宁县| 永寿县| 惠水县| 邮箱| 宾阳县| 铁岭市| 隆安县| 连南| 长泰县| 韩城市| 翁牛特旗| 耒阳市| 正宁县|