<html><head>
<style id="css_styles">
blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc }
blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding-top: 0px; }
a img { border: 0px; }
li[style='text-align: center;'], li[style='text-align: right;'] { list-style-position: inside;}
body { font-family: Atlanta; font-size: 10pt; }
</style>
</head>
<body><div>Hi,</div><div>recently I'm having problems with pg_dump on pgpool. The master node server crashes and the switch occurs on the standby. Here are the lines of the pgpool.log:</div><div><br /></div><div>LOG: pool_read_kind: error message from master backend:sorry, too many clients already<br />ERROR: unable to read message kind<br />DETAIL: kind does not match between master(45) slot[1] (52)<br />LOG: watchdog received the failover command from remote pgpool-II node "xx.xx.xx.xx:5432 Linux server1"<br />LOG: watchdog is processing the failover command [DEGENERATE_BACKEND_REQUEST] received from xx.xx.xx.xx:5432 Linux server1<br />LOG: remote pgpool-II node "xx.xx.xx.xx:5432 Linux server1" is requesting to become a lock holder for failover ID: 0<br />LOG: lock holder request denied to remote pgpool-II node "xx.xx.xx.xx:5432 Linux server1"<br />DETAIL: local pgpool-II node "yy.yy.yy.yy:5432 Linux server2" is already holding the locks<br />LOG: received the failover command lock request from remote pgpool-II node "xx.xx.xx.xx:5432 Linux server1"<br />LOG: remote pgpool-II node "xx.xx.xx.xx:5432 Linux server1" is checking the status of [FAILOVER] lock for failover ID 0</div><div><br /></div><div>It would seem to depend on the number of connections exceeded (from the string that appears in the log: "sorry, too many clients already"). I already have max_connections = 300. Is there a way to verify that this was the problem?</div><div>if I tried to execute the pg_dump directly on the standby postgresql server, without going through pgpool, using port 5433, could I avoid the problem according to you?</div>
</body></html>