PgSql数据库状态管理

• 查看数据库链接数和状态 SELECT * FROM pg_stat_activity;
• 断开所有数据库连接 除自己以外

  SELECT pg_terminate_backend(pg_stat_activity.pid)
  FROM pg_stat_activity
  WHERE datname='dbname' AND pid<>pg_backend_pid();