pgpool连接问题

Question

搭建好postgresql主从流复制 与pgpool主备后，连接pgpool出现问题：

[root@vm129 ~]# psql -h 192.168.1.168 -p 9999 -U postgres -d postgres
psql: ERROR:  pgpool is not accepting any new connections
DETAIL:  all backend nodes are down, pgpool requires at least one valid node
HINT:  repair the backend nodes and restart pgpool

连接时的日志如下：

2016-08-03 14:58:52: pid 1118: DEBUG:  watchdog life checking by heartbeat
2016-08-03 14:58:52: pid 1118: DETAIL:  checking pgpool 0 (192.168.1.129:9999)
2016-08-03 14:58:52: pid 1118: DEBUG:  watchdog life checking by heartbeat
2016-08-03 14:58:52: pid 1118: DETAIL:  OK; status 3
2016-08-03 14:58:52: pid 1118: DEBUG:  watchdog life checking by heartbeat
2016-08-03 14:58:52: pid 1118: DETAIL:  checking pgpool 1 (192.168.1.130:9999)
2016-08-03 14:58:52: pid 1118: DEBUG:  watchdog checking if pgpool is alive using heartbeat
2016-08-03 14:58:52: pid 1118: DETAIL:  the last heartbeat from "192.168.1.130:9999" received 0 seconds ago
2016-08-03 14:58:52: pid 1118: DEBUG:  checking pgpool status by heartbeat
2016-08-03 14:58:52: pid 1118: DETAIL:  OK; status 2
2016-08-03 14:58:52: pid 1117: DEBUG:  watchdog heartbeat: send heartbeat signal to 192.168.1.130:9694
2016-08-03 14:58:54: pid 1116: DEBUG:  watchdog heartbeat: received heartbeat signal from "192.168.1.130:9999"
2016-08-03 14:58:54: pid 1117: DEBUG:  watchdog heartbeat: send heartbeat signal to 192.168.1.130:9694
2016-08-03 14:58:56: pid 1116: DEBUG:  watchdog heartbeat: received heartbeat signal from "192.168.1.130:9999"
2016-08-03 14:58:56: pid 1117: DEBUG:  watchdog heartbeat: send heartbeat signal to 192.168.1.130:9694
2016-08-03 14:58:56: pid 1195: DEBUG:  reading startup packet
2016-08-03 14:58:56: pid 1195: DETAIL:  application_name: psql
2016-08-03 14:58:56: pid 1195: DEBUG:  reading startup packet
2016-08-03 14:58:56: pid 1195: DETAIL:  Protocol Major: 3 Minor: 0 database: postgres user: postgres
2016-08-03 14:58:56: pid 1195: DEBUG:  forwarding error message to frontend
2016-08-03 14:58:56: pid 1195: FATAL:  pgpool is not accepting any new connections
2016-08-03 14:58:56: pid 1195: DETAIL:  all backend nodes are down, pgpool requires at least one valid node
2016-08-03 14:58:56: pid 1195: HINT:  repair the backend nodes and restart pgpool
2016-08-03 14:58:56: pid 1109: DEBUG:  reaper handler
2016-08-03 14:58:56: pid 1109: LOG:  child process with pid: 1195 exits with status 256
2016-08-03 14:58:56: pid 1109: LOG:  fork a new child process with pid: 1198
2016-08-03 14:58:56: pid 1109: DEBUG:  reaper handler: exiting normally
2016-08-03 14:58:56: pid 1198: DEBUG:  initializing backend status
2016-08-03 14:58:58: pid 1116: DEBUG:  watchdog heartbeat: received heartbeat signal from "192.168.1.130:9999"

Answer 1

引用来自“平安北京”的评论

这个请
@宏哥 来吧

Answer 2

这个请
@宏哥 来吧