07 2015 档案

postgreSQL 时间线
摘要：“时间线”（Timeline）是PG一个很有特色的概念，在备份恢复方面的文档里面时有出现。但针对这个概念的详细解释却很少，也让人不太好理解，我们在此仔细解析一下。时间线的引入为了理解引入时间线的背景，我们来分析一下，如果没有时间线，会有什么问题？先举个将数据库恢复到以前时间点的例子。假设在一个数据库... 阅读全文

posted @ 2015-07-21 23:27 Still water run deep 阅读(3336) 评论(0) 推荐(1)

Using CSV-Format Log Output
摘要：Including csvlog in the log_destination list provides a convenient way to import log files into a database table. This option emits log lines in comma... 阅读全文

posted @ 2015-07-20 17:18 Still water run deep 阅读(302) 评论(0) 推荐(0)

Understanding postgresql.conf : log*
摘要：After loooong pause, adding next (well, second) post to the “series“. This time, I'd like to describe how logging works. And I don't mean binary loggi... 阅读全文

posted @ 2015-07-20 08:12 Still water run deep 阅读(1044) 评论(0) 推荐(0)

UNDERSTANDING POSTGRESQL.CONF: CHECKPOINT_SEGMENTS, CHECKPOINT_TIMEOUT, CHECKPOINT_WARNING
摘要：While there are somedocson it, I decided to write about it, in perhaps more accessible language – not as a developer, but as PostgreSQL user.Some part... 阅读全文

posted @ 2015-07-15 08:42 Still water run deep 阅读(590) 评论(0) 推荐(0)

PgSQL · 追根究底 · WAL日志空间的意外增长
摘要：问题出现我们在线上巡检中发现，一个实例的pg_xlog目录，增长到4G，很是疑惑。刚开始怀疑是日志归档过慢，日志堆积在pg_xlog目录下面，未被清除导致。于是检查归档目录下的文件，内容如下。但发现新近完成写入的日志文件都被归档成功了（即在pg_xlog/archive_status里面，有对应的x... 阅读全文

posted @ 2015-07-13 00:42 Still water run deep 阅读(2872) 评论(6) 推荐(1)

Maximum number of WAL files in the pg_xlog directory (2)
摘要：Jeff Janes:Hi,As part of our monitoring work for our customers, we stumbled upon an issue with our customers' servers who have a wal_keep_segments set... 阅读全文

posted @ 2015-07-13 00:08 Still water run deep 阅读(506) 评论(0) 推荐(0)

Maximum number of WAL files in the pg_xlog directory (1)
摘要：Guillaume Lelarge:Hi,As part of our monitoring work for our customers, we stumbled upon an issue with our customers' servers who have a wal_keep_segme... 阅读全文

posted @ 2015-07-12 23:29 Still water run deep 阅读(655) 评论(0) 推荐(0)

导航