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

  • Mastering PostgreSQL 9.6
  • Hans Jurgen Schonig
  • 129字
  • 2021-07-09 19:57:09

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.

主站蜘蛛池模板: 固安县| 庄河市| 昂仁县| 兴海县| 当雄县| 封开县| 崇仁县| 汕头市| 新建县| 富蕴县| 宿松县| 普宁市| 万载县| 万山特区| 定州市| 澎湖县| 罗田县| 义乌市| 灵山县| 唐海县| 黑龙江省| 独山县| 台湾省| 密云县| 闸北区| 湖州市| 鸡东县| 南平市| 江陵县| 赤城县| 铁力市| 阳高县| 旺苍县| 三亚市| 万宁市| 凌源市| 富锦市| 平果县| 乌兰浩特市| 五家渠市| 广河县|