- 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.
- Hands-On Graph Analytics with Neo4j
- 我的J2EE成功之路
- 極簡(jiǎn)AI入門:一本書讀懂人工智能思維與應(yīng)用
- 微型計(jì)算機(jī)控制技術(shù)
- Visual Basic從初學(xué)到精通
- OpenStack Cloud Computing Cookbook
- 單片機(jī)C語(yǔ)言應(yīng)用100例
- 網(wǎng)絡(luò)脆弱性掃描產(chǎn)品原理及應(yīng)用
- 電腦上網(wǎng)入門
- 工業(yè)機(jī)器人操作
- 手把手教你學(xué)Photoshop CS3
- Eclipse全程指南
- Hands-On Geospatial Analysis with R and QGIS
- Web滲透技術(shù)及實(shí)戰(zhàn)案例解析
- Learn Power BI