[pgpool-general: 6718] Can't restart pgpool on SLAVE node (that is	primary postgres server)
    Giancarlo Celli 
    giancarlo.celli at flottaweb.com
       
    Mon Sep 23 19:03:48 JST 2019
    
    
  
Hi,
I had to kill the pgpool process to change the master on the other node. 
I also removed the pgpool.pid.
Now this is the situation:
NODE A:
- Master pgpool ON
- Standby postgres ON
NODE B:
- Slave pgpool DOWN
- Primary postgres ON
My problem is that if I try to restart pgpool on NODE B (SLAVE pgpool), 
it not works.
In the log I see that initially it starts up correctly, but then the 
following error appears and pgpool goes down again:
FATAL:  failed to bind a socket: "/tmp/.s.PGSQL.5432"
DETAIL:  bind socket failed with error: "Address already in use"
LOG:  Watchdog is shutting down
I cannot stop postgres because it is primary server.
What can I do for start pgpool on SLAVE pgpool?
Best regards.
Giancarlo Celli
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20190923/99dd8247/attachment.htm>
    
    
More information about the pgpool-general
mailing list