<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body>
<font face="Helvetica, Arial, sans-serif">Hi,<br>
I had to kill the pgpool process to change the master on the other
node. I also removed the pgpool.pid.<br>
Now this is the situation:<br>
<br>
NODE A:<br>
- Master pgpool ON<br>
- Standby postgres ON<br>
<br>
NODE B:<br>
- Slave pgpool DOWN<br>
- Primary postgres ON<br>
<br>
My problem is that if I try to restart pgpool on NODE B (SLAVE
pgpool), it not works.<br>
In the log I see that initially it starts up correctly, but then
the following error appears and pgpool goes down again:<br>
<br>
FATAL: failed to bind a socket: "/tmp/.s.PGSQL.5432"<br>
DETAIL: bind socket failed with error: "Address already in use"<br>
LOG: Watchdog is shutting down<br>
<br>
I cannot stop postgres because it is primary server.<br>
What can I do for start pgpool on SLAVE pgpool?<br>
<br>
Best regards.<br>
<br>
Giancarlo Celli<br>
</font>
</body>
</html>