阿里云
>
日志
>
管理可靠性日志
管理可靠性日志
PostgreSQL 10.1 手册_部分 III.服务器
管理
_第 30 章
可靠性
和预写式
日志
_30.1.
可靠性
30.1.
可靠性
可靠性
是任何严肃的数据库系统的重要属性,PostgreSQL尽一切可能来保证可靠的操作。可靠的操作的一个方面是,被一个提交事务记录的所有数据应该被存储在一个非易失的区域,这样就不会因为失去电力、操作系统失败以及硬件失败...
PostgreSQL 10.1 手册_部分 III.服务器
管理
_第 30 章
可靠性
和预写式
日志
第 30 章
可靠性
和预写式
日志
目录 30.1.
可靠性
30.2.预写式
日志
(WAL)30.3.异步提交 30.4.WAL配置 30.5.WAL内部 本章解释预写式
日志
如何用于获得有效的、可靠的操作。本文转自PostgreSQL中文社区,原文链接:第 30 章
可靠性
和预写式
日志
服务器
管理
_第 30 章
可靠性
和预写式
日志
_30.2.预写式
日志
(WAL)
30.2.预写式
日志
(WAL)预写式
日志
(WAL)是保证数据完整
性
的一种标准方法。对其详尽的描述几乎可以在所有(如果不是全部)有关事务处理的书中找到。简单来说,WAL的中心概念是数据文件(存储着表和索引)的修改必须在这些动作被
日志
记录...
PostgreSQL 10.1 手册_部分 III...服务器
管理
_第 30 章
可靠性
和预写式
日志
_30.5.WAL内部
除了做一些设置满足存放WAL
日志
的磁盘空间需求以及一些必要的调节以外(参阅第 30.4 节),对
管理
员没有什么其他要求。当每个新记录被写入时,WAL记录被追加到WAL
日志
中。插入位置由
日志
序列号(LSN)描述,该
日志
序列号是
日志
中的字节偏移...
PostgreSQL 10.1 手册_部分 III...服务器
管理
_第 30 章
可靠性
和预写式
日志
_30.4.WAL配置
只要满足
可靠性
,那么除了fsync_writethrough所有选项应该都是一样的,fsync_writethrough可以在某些时候强制磁盘高速缓存的刷写,而其他选项不能这样做。不过,哪种选项最快则可能和平台密切相关。你可以使用pg_test_fsync程序来测试不同...
PostgreSQL 10.1 手册_部分 ...服务器
管理
_第 30 章
可靠性
和预写式
日志
_30.3.异步提交
但是在很多情境中不需要这种强的保证,例如事件
日志
。使用异步提交带来的风险是数据丢失,而不是数据损坏。如果数据库可能崩溃,它会通过重放WAL到被刷写的最后一个记录来进行恢复。数据库将因此被恢复到一个自身一致状态,但是任何还没有...
1
日志可靠性管理相关内容
.
服务器管理可靠性日志
日志更多"可靠性"相关
.
服务器可靠性日志
日志管理可靠性相关内容
.
linux日志管理
.
mysql日志管理
.
配置日志管理
.
管理服务器日志
.
日志异常管理
.
docker管理日志
.
rsyslog日志管理
.
web日志管理
.
管理日志提交
.
rdiframework.net日志管理
您可能感兴趣
.
spring日志
.
oracle日志
.
springboot日志
.
框架日志
.
日志脚本
.
日志开发
.
日志log文件
.
linux日志
{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":5,"count":5}]},"card":[{"des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","link1":"https://www.aliyun.com/product/sls","link":"https://www.aliyun.com/product/sls","icon":"https://img.alicdn.com/tfs/TB1_VAXxXOWBuNjy0FiXXXFxVXa-200-200.png","btn2":"免费额度(500MB)","tip":"日志分析就用日志服务,海量日志智能分析,
立即查看
最新产品和实时动态重磅发布,
立即查看
","btn1":"立即开通","link2":"https://www.aliyun.com/price/product?spm=5176.55536.857803.price.740a121eIswPup#/sls/detail","title":"日志服务"}],"search":[{"txt":"服务介绍","link":"https://help.aliyun.com/document_detail/48869.html"},{"txt":"操作视频","link":"https://help.aliyun.com/video_list/55125.html"},{"txt":"常用案例","link":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11174359.6.741.u4QcxG"},{"txt":"最新功能","link":"https://www.aliyun.com/product/new?spm=5176.55536.857803.1.740a121eIswPup&category=12&product=101"},{"txt":"产品动态","link":"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"icon","icon":"sls","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","contentLink":"https://www.aliyun.com/product/sls?spm=5176.10695662.1119587.1.53da2b1cHgIGOy","title":"日志服务SLS","des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","btn1":"立即开通","btn2":"了解价格","btn3":"产品文档","link1":"https://sls.console.aliyun.com/lognext/profile","link2":"https://www.aliyun.com/price/product?spm=5176.10695662.1119587.3.53da2b1cHgIGOy#/sls/detail","link3":"https://help.aliyun.com/document_detail/48869.html?spm=5176.55536.1250727.4.7282121eGNaACU","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"短信服务日志上线","lastContentName":"","firstContentLink":"https://help.aliyun.com/document_detail/147243.html?spm=5176.55536.1250727.8.7282121eGNaACU","lastContentLink":""}},{"infoName":"产品入门","infoContent":{"firstContentName":"快速学习","firstContentLink":"https://help.aliyun.com/learn/learningpath/log.html?spm=5176.55536.1250727.3.7282121eGNaACU","lastContentLink":"https://promotion.aliyun.com/ntms/act/logdoclist.html?spm=5176.55536.1250727.1.7282121eGNaACU","lastContentName":"用户手册与demo"}},{"infoName":"最新视频","infoContent":{"firstContentName":"K8S事件中心(免费)","lastContentName":"日志审计发布会","firstContentLink":"https://yq.aliyun.com/live/2174?spm=5176.55536.1250727.12.7282121eGNaACU","lastContentLink":"https://yq.aliyun.com/live/1534?spm=5176.55536.1250727.14.7282121eGNaACU"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"典型使用场景","firstContentLink":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11186623.6.1207.65fa735djyTizh"}}]}]}
{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":5,"count":5}]},"card":[{"des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","link1":"https://www.aliyun.com/product/sls","link":"https://www.aliyun.com/product/sls","icon":"https://img.alicdn.com/tfs/TB1_VAXxXOWBuNjy0FiXXXFxVXa-200-200.png","btn2":"免费额度(500MB)","tip":"日志分析就用日志服务,海量日志智能分析,
立即查看
最新产品和实时动态重磅发布,
立即查看
","btn1":"立即开通","link2":"https://www.aliyun.com/price/product?spm=5176.55536.857803.price.740a121eIswPup#/sls/detail","title":"日志服务"}],"search":[{"txt":"服务介绍","link":"https://help.aliyun.com/document_detail/48869.html"},{"txt":"操作视频","link":"https://help.aliyun.com/video_list/55125.html"},{"txt":"常用案例","link":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11174359.6.741.u4QcxG"},{"txt":"最新功能","link":"https://www.aliyun.com/product/new?spm=5176.55536.857803.1.740a121eIswPup&category=12&product=101"},{"txt":"产品动态","link":"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"icon","icon":"sls","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","contentLink":"https://www.aliyun.com/product/sls?spm=5176.10695662.1119587.1.53da2b1cHgIGOy","title":"日志服务SLS","des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","btn1":"立即开通","btn2":"了解价格","btn3":"产品文档","link1":"https://sls.console.aliyun.com/lognext/profile","link2":"https://www.aliyun.com/price/product?spm=5176.10695662.1119587.3.53da2b1cHgIGOy#/sls/detail","link3":"https://help.aliyun.com/document_detail/48869.html?spm=5176.55536.1250727.4.7282121eGNaACU","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"短信服务日志上线","lastContentName":"","firstContentLink":"https://help.aliyun.com/document_detail/147243.html?spm=5176.55536.1250727.8.7282121eGNaACU","lastContentLink":""}},{"infoName":"产品入门","infoContent":{"firstContentName":"快速学习","firstContentLink":"https://help.aliyun.com/learn/learningpath/log.html?spm=5176.55536.1250727.3.7282121eGNaACU","lastContentLink":"https://promotion.aliyun.com/ntms/act/logdoclist.html?spm=5176.55536.1250727.1.7282121eGNaACU","lastContentName":"用户手册与demo"}},{"infoName":"最新视频","infoContent":{"firstContentName":"K8S事件中心(免费)","lastContentName":"日志审计发布会","firstContentLink":"https://yq.aliyun.com/live/2174?spm=5176.55536.1250727.12.7282121eGNaACU","lastContentLink":"https://yq.aliyun.com/live/1534?spm=5176.55536.1250727.14.7282121eGNaACU"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"典型使用场景","firstContentLink":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11186623.6.1207.65fa735djyTizh"}}]}]}}
日志服务SLS
日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。
立即开通
了解价格
产品文档
最新活动
短信服务日志上线
产品入门
快速学习
用户手册与demo
最新视频
K8S事件中心(免费)
日志审计发布会
最佳实践
典型使用场景
{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":5,"count":5}]},"card":[{"des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","link1":"https://www.aliyun.com/product/sls","link":"https://www.aliyun.com/product/sls","icon":"https://img.alicdn.com/tfs/TB1_VAXxXOWBuNjy0FiXXXFxVXa-200-200.png","btn2":"免费额度(500MB)","tip":"日志分析就用日志服务,海量日志智能分析,
立即查看
最新产品和实时动态重磅发布,
立即查看
","btn1":"立即开通","link2":"https://www.aliyun.com/price/product?spm=5176.55536.857803.price.740a121eIswPup#/sls/detail","title":"日志服务"}],"search":[{"txt":"服务介绍","link":"https://help.aliyun.com/document_detail/48869.html"},{"txt":"操作视频","link":"https://help.aliyun.com/video_list/55125.html"},{"txt":"常用案例","link":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11174359.6.741.u4QcxG"},{"txt":"最新功能","link":"https://www.aliyun.com/product/new?spm=5176.55536.857803.1.740a121eIswPup&category=12&product=101"},{"txt":"产品动态","link":"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"icon","icon":"sls","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","contentLink":"https://www.aliyun.com/product/sls?spm=5176.10695662.1119587.1.53da2b1cHgIGOy","title":"日志服务SLS","des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","btn1":"立即开通","btn2":"了解价格","btn3":"产品文档","link1":"https://sls.console.aliyun.com/lognext/profile","link2":"https://www.aliyun.com/price/product?spm=5176.10695662.1119587.3.53da2b1cHgIGOy#/sls/detail","link3":"https://help.aliyun.com/document_detail/48869.html?spm=5176.55536.1250727.4.7282121eGNaACU","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"短信服务日志上线","lastContentName":"","firstContentLink":"https://help.aliyun.com/document_detail/147243.html?spm=5176.55536.1250727.8.7282121eGNaACU","lastContentLink":""}},{"infoName":"产品入门","infoContent":{"firstContentName":"快速学习","firstContentLink":"https://help.aliyun.com/learn/learningpath/log.html?spm=5176.55536.1250727.3.7282121eGNaACU","lastContentLink":"https://promotion.aliyun.com/ntms/act/logdoclist.html?spm=5176.55536.1250727.1.7282121eGNaACU","lastContentName":"用户手册与demo"}},{"infoName":"最新视频","infoContent":{"firstContentName":"K8S事件中心(免费)","lastContentName":"日志审计发布会","firstContentLink":"https://yq.aliyun.com/live/2174?spm=5176.55536.1250727.12.7282121eGNaACU","lastContentLink":"https://yq.aliyun.com/live/1534?spm=5176.55536.1250727.14.7282121eGNaACU"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"典型使用场景","firstContentLink":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11186623.6.1207.65fa735djyTizh"}}]}]}
{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":5,"count":5}]},"card":[{"des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","link1":"https://www.aliyun.com/product/sls","link":"https://www.aliyun.com/product/sls","icon":"https://img.alicdn.com/tfs/TB1_VAXxXOWBuNjy0FiXXXFxVXa-200-200.png","btn2":"免费额度(500MB)","tip":"日志分析就用日志服务,海量日志智能分析,
立即查看
最新产品和实时动态重磅发布,
立即查看
","btn1":"立即开通","link2":"https://www.aliyun.com/price/product?spm=5176.55536.857803.price.740a121eIswPup#/sls/detail","title":"日志服务"}],"search":[{"txt":"服务介绍","link":"https://help.aliyun.com/document_detail/48869.html"},{"txt":"操作视频","link":"https://help.aliyun.com/video_list/55125.html"},{"txt":"常用案例","link":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11174359.6.741.u4QcxG"},{"txt":"最新功能","link":"https://www.aliyun.com/product/new?spm=5176.55536.857803.1.740a121eIswPup&category=12&product=101"},{"txt":"产品动态","link":"https://www.aliyun.com/product/new?source_type=out_sousuo_feature_0716"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"icon","icon":"sls","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","contentLink":"https://www.aliyun.com/product/sls?spm=5176.10695662.1119587.1.53da2b1cHgIGOy","title":"日志服务SLS","des":"日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。","btn1":"立即开通","btn2":"了解价格","btn3":"产品文档","link1":"https://sls.console.aliyun.com/lognext/profile","link2":"https://www.aliyun.com/price/product?spm=5176.10695662.1119587.3.53da2b1cHgIGOy#/sls/detail","link3":"https://help.aliyun.com/document_detail/48869.html?spm=5176.55536.1250727.4.7282121eGNaACU","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"短信服务日志上线","lastContentName":"","firstContentLink":"https://help.aliyun.com/document_detail/147243.html?spm=5176.55536.1250727.8.7282121eGNaACU","lastContentLink":""}},{"infoName":"产品入门","infoContent":{"firstContentName":"快速学习","firstContentLink":"https://help.aliyun.com/learn/learningpath/log.html?spm=5176.55536.1250727.3.7282121eGNaACU","lastContentLink":"https://promotion.aliyun.com/ntms/act/logdoclist.html?spm=5176.55536.1250727.1.7282121eGNaACU","lastContentName":"用户手册与demo"}},{"infoName":"最新视频","infoContent":{"firstContentName":"K8S事件中心(免费)","lastContentName":"日志审计发布会","firstContentLink":"https://yq.aliyun.com/live/2174?spm=5176.55536.1250727.12.7282121eGNaACU","lastContentLink":"https://yq.aliyun.com/live/1534?spm=5176.55536.1250727.14.7282121eGNaACU"}},{"infoName":"最佳实践","infoContent":{"firstContentName":"典型使用场景","firstContentLink":"https://help.aliyun.com/document_detail/29090.html?spm=a2c4g.11186623.6.1207.65fa735djyTizh"}}]}]}}
日志服务SLS
日志服务(Log Service,简称LOG/原SLS)是针对实时数据一站式服务,在阿里集团经历大量大数据场景锤炼而成。提供日志类数据采集、消费、投递及查询分析功能,全面提升海量日志处理/分析能力。
立即开通
了解价格
产品文档
最新活动
短信服务日志上线
产品入门
快速学习
用户手册与demo
最新视频
K8S事件中心(免费)
日志审计发布会
最佳实践
典型使用场景