- 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.
- Java編程全能詞典
- Practical Ansible 2
- 基于LabWindows/CVI的虛擬儀器設(shè)計與應用
- Mastering Elastic Stack
- 精通特征工程
- 統(tǒng)計學習理論與方法:R語言版
- 網(wǎng)絡(luò)化分布式系統(tǒng)預測控制
- Splunk Operational Intelligence Cookbook
- Visual FoxPro數(shù)據(jù)庫基礎(chǔ)及應用
- Apache源代碼全景分析(第1卷):體系結(jié)構(gòu)與核心模塊
- Learning Linux Shell Scripting
- 手機游戲策劃設(shè)計
- 漢字錄入技能訓練
- 計算機應用基礎(chǔ)學習指導與練習(Windows XP+Office 2003)
- Mastering Windows Group Policy