[pgpool-general: 6722] Re: Can't restart pgpool on SLAVE node (that is primary postgres server)

[Giancarlo Celli]

Very good!
Removing /tmp/.s.PGSQL.5432 problem was resolved.
Thanks!
Best regards.


>> 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
> How did you kill pgpool on node B? If it's something like kill -9 or
> something rude way then pgpool sockt would remain. In this case you
> need to manually remove pgpool socket (I am assuming it's
> /tmp/.s.PGSQL.5432):
>
> rm /tmp/.s.PGSQL.5432
>
>> I cannot stop postgres because it is primary server.
>> What can I do for start pgpool on SLAVE pgpool?
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190924/76cfecdc/attachment-0001.html>