11 2014 档案

pyzmq missing when running ipython notebook
摘要：Q:I can run iPython, but when I try to initiate a notebook I get the following error:~ ipython notebook Traceback (most recent call... 阅读全文

posted @ 2014-11-08 01:26 Still water run deep 阅读(583) 评论(0) 推荐(0)

在CentOS上安装Python
摘要：首先我们需要在服务器上安装一个比较新的 Python，CentOS 5.8 默认装的 Python 是 2.4.3。[root@nowamagic ~]# python -VPython 2.4.3我们需要自己安装Python 2.7.5。但是值得注意的是，我们必须不能破坏系统的环境。因为几个关键的... 阅读全文

posted @ 2014-11-07 22:47 Still water run deep 阅读(338) 评论(0) 推荐(0)

pip使用报错【cannot import name HTTPSHandler】
摘要：python2.7，报错如下：Traceback (most recent call last): File "/usr/local/bin/pip", line 9, in load_entry_point('pip==1.4.1', 'console_scripts', 'pip')() F... 阅读全文

posted @ 2014-11-07 22:44 Still water run deep 阅读(5687) 评论(0) 推荐(0)

Is it possible to configure PostgreSQL to automatically close idle connections?
摘要：1、use pgbouncerAs new connections/transactions/statements arrive, the pool will increase in size up to thedefined user maximums. Those connections wil... 阅读全文

posted @ 2014-11-02 11:29 Still water run deep 阅读(560) 评论(0) 推荐(0)

How to drop a PostgreSQL database if there are active connections to it?
摘要：1、PostgreSQL 9.1 and below:SELECT pg_terminate_backend(pg_stat_activity.procpid)FROM pg_stat_activityWHERE pg_stat_activity.datname = 'TARGET_DB' AND... 阅读全文

posted @ 2014-11-01 19:30 Still water run deep 阅读(333) 评论(0) 推荐(0)

pgbouncer配置
摘要：DESCRIPTIONpgbounceris a PostgreSQL connection pooler. Any target application can be connected topgbounceras if it were a PostgreSQL server, andpgboun... 阅读全文

posted @ 2014-11-01 16:18 Still water run deep 阅读(439) 评论(0) 推荐(0)

导航