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

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.

主站蜘蛛池模板: 织金县| 府谷县| 武强县| 楚雄市| 怀宁县| 安泽县| 师宗县| 平昌县| 敦化市| 孟连| 德阳市| 涞源县| 华蓥市| 锡林浩特市| 高密市| 本溪| 库尔勒市| 新乡县| 天等县| 新化县| 汉中市| 浮山县| 余姚市| 广水市| 三穗县| 莎车县| 金门县| 兴山县| 岐山县| 贵南县| 屏边| 布尔津县| 贵阳市| 凯里市| 古丈县| 开阳县| 绥芬河市| 汝州市| 辽源市| 宜川县| 泰宁县|