<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi all;<br>
<br>
I've setup a simple pg pool install:<br>
<br>
1) installed postgresql95 postgresql95-server and
postgresql95-contrib via the yum repo file found at
yum.postgresql.org (centOS 6 x86_64)<br>
<br>
2) setup 2 nodes (VM's) with postgres 9.5 as a master/slave
(streaming replication and verified replication is working<br>
<br>
3) installed pgpool on a 3rd VM:<br>
yum install pgpool-II-95-extensions pgpoolAdmin pgpool-II-95<br>
<br>
4) configured a basic pgpool.conf file based on a copy of
pgpool.conf.sample-stream (in /etc/pgpool-II-95)<br>
<br>
5) setup a basic pool_passwd file using the hash for the postgres
user's passwd<br>
<br>
6) setup a basic pcp.conf file with the same postgres user's
password hash<br>
<br>
7) was able to connect via psql -p 9999 -h localhost (on the pgpool
VM<br>
<br>
8) enabled the heartbeat in the pgpool.conf file but did not setup
failover / failback commands<br>
<br>
9) stopped the postgresql master db<br>
<br>
10) my connection to pgpool (step 7 above) printed this:<br>
<i>server closed the connection unexpectedly</i><i><br>
</i><i> This probably means the server terminated abnormally</i><i><br>
</i><i> before or while processing the request.</i><i><br>
</i><i>The connection to the server was lost. Attempting reset:
Succeeded.</i><br>
<br>
11) restarted the backend master<br>
<br>
Now I can connect to pgpool (as in step 7 above) but I always
connect to the slave. How can I tell pgpool to return to connecting
to the master?<br>
<br>
Running a pcp_node_count shows 2 but I suspect I'm skipping a
'failback' step of some kind.<br>
<br>
thanks in advance<br>
<br>
</body>
</html>