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

  • 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.

主站蜘蛛池模板: 松原市| 始兴县| 油尖旺区| 沙洋县| 舟山市| 九寨沟县| 阳曲县| 工布江达县| 贺州市| 姜堰市| 贵南县| 申扎县| 唐山市| 漳州市| 会东县| 泸溪县| 余干县| 石景山区| 安塞县| 长汀县| 达日县| 民乐县| 汶川县| 大荔县| 会理县| 铅山县| 德昌县| 灵宝市| 耿马| 阳谷县| 通道| 会宁县| 黑河市| 六安市| 宁陕县| 浮山县| 金华市| 桐城市| 泸溪县| 游戏| 西贡区|