2014年11月1日

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 阅读(321) 评论(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 阅读(423) 评论(0) 推荐(0) 编辑

导航