摘要: http://blog.csdn.net/hantiannan/article/details/4517192http://www.cnblogs.com/gaojian/archive/2012/11/08/2759874.htmlhttp://m.oschina.net/blog/135872h... 阅读全文
posted @ 2014-05-30 17:33 bielidefeng 阅读(333) 评论(0) 推荐(0)
摘要: ubuntu追加空间http://blog.csdn.net/openme_openwrt/article/details/8099956-------------------播放视频avi等使用SMPLAYER播放器-----------终端目录的说明使用“/usr/.....”===>系统目录... 阅读全文
posted @ 2014-05-30 11:05 bielidefeng 阅读(477) 评论(0) 推荐(0)
摘要: ----------ps -ewf显示所有进程,ps -a|grep ss指的是显示ss关键字的所有进程。top是动态显示进程。---------cat直接将文件内容显示在终端上。 ---------查看linux系统版本信息cat /etc/*release。---------从一台Linux机子... 阅读全文
posted @ 2014-05-30 11:04 bielidefeng 阅读(298) 评论(0) 推荐(0)
摘要: http://www.postgresql.org/docs/9.3/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICSEXECUTE format('UPDATE tbl SET %I = $1 WHERE key = $2'... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(101) 评论(0) 推荐(0)
摘要: btree & hash索引:http://www.kankanews.com/ICkengine/archives/127746.shtmlhttp://blog.csdn.net/tonyxf121/article/details/7976824http://www.uml.org.cn/sjj... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(181) 评论(0) 推荐(0)
摘要: http://blog.163.com/digoal@126/blog/static/1638770402014395222222/pg_current_xlog_insert_location函数:指的是写入wal buffer的位置pg_current_xlog_location函数:指的是已经... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(255) 评论(0) 推荐(0)
摘要: max_pool,num_init_children :通过pgpool连接进数据库的个数不能超过 num_init_children * max_pool 个connection_life_time:缓存的连接的过期时长。(超过num_init_children * max_pool后在一定空闲时... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(1376) 评论(0) 推荐(0)
摘要: 参看:http://blog.163.com/czg_e/blog/static/461045612012129105020629/http://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-zh_cn.html#connection_pool... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(635) 评论(0) 推荐(0)
摘要: postgresql 流复制:http://francs3.blog.163.com/blog/static/4057672720136210240967/master(127.0.0.1:5432):数据目录:/home/pg93/test_rep/datainitdb -D $PGDATA -E... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(183) 评论(0) 推荐(0)
摘要: postgresql利用归档文件恢复:http://bbs.chinaunix.net/thread-1771360-1-1.html http://blog.163.com/digoal@126/blog/static/16387704020110442050808/ master:ip:127... 阅读全文
posted @ 2014-05-30 10:34 bielidefeng 阅读(169) 评论(0) 推荐(0)