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)

导航