普通用户登陆时出现报错信息:
psql: FATAL: remaining connection slots are reserved for non-replication superuser connections原因:连接数已满
解决方法:
1. 管理员登录系统关闭空闲连接
# 查询当前所有连接的状态
postgres=# select datname,pid,usename,client_addr,application_name,state from pg_stat_activity;
datname | pid | usename | client_addr | application_name | state
---------+------+---------+----------------+------------------------+--------
| 444 | | | |
| 446 | nlpku | | |
hrjlk | 447 | hrjlk | 172.24.105.173 | psql | idle
hrjlk | 1081 | hrjlk | 172.24.105.172 | PostgreSQL JDBC Driver | idle
hrjlk | 1082 | hrjlk | 172.24.105.172 | PostgreSQL JDBC D