摘要: http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html参考官方文档:wal_keep_segments (integer)Specifies the minimum number of past log file segments kept in the pg_xlog directory, in case a standby server needs to fetch them for streaming replication. Each segment is normally 16 megabyt 阅读全文
posted @ 2013-10-07 14:36 健哥的数据花园 阅读(6127) 评论(0) 推荐(0) 编辑
摘要: 官方文档:http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html为了防止slave端读取数据时,因为读到的是旧有数据而被强制取消,设定了这么一个以transaction为单位的值。就是可以保证经过这么多的trsanction后,数据仍然得以为slave 几点到读取而保留。vacuum_defer_cleanup_age (integer)Specifies the number of transactions by which VACUUM and HOT updates will defer clea 阅读全文
posted @ 2013-10-07 13:20 健哥的数据花园 阅读(1177) 评论(0) 推荐(0) 编辑
摘要: 磨砺技术珠矶,践行数据之道,追求卓越价值回到上一级页面:PostgreSQL基础知识与基本操作索引页 回到顶级页面:PostgreSQL索引页[作者 高健@博客园 luckyjackgao@gmail.com]参考:http://space.itpub.net/133735/viewspace-742081官方资料:http://www.postgresql.org/docs/9.3/static/app-pgbasebackup.htmlThe backup is made over a regular PostgreSQL connection, and uses the replica. 阅读全文
posted @ 2013-10-07 12:57 健哥的数据花园 阅读(2440) 评论(0) 推荐(0) 编辑