[pgpool-general: 6029] Re: Online Recovery Script with Systemd

Tatsuo Ishii ishii at sraoss.co.jp
Thu Apr 5 22:34:40 JST 2018


I am not familiar with systemctl but I can understand the issue you
found. It seems your solution is resonable (changing
pgpool_remote_start so that it executes systemctl rather than
pg_ctl). Please let us know you succeed or not.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Hi,
> 
> does anyone have problems with the scripts for online recovery and systemd on CentOS? (On Ubuntu with Systemd I didn’t at least recognize such a problem)..
> 
> The script “pgpool_remote_start” starts postgresql like that:
> ssh -T $remote_host $pghome/bin/pg_ctl -w -D $remote_pgdata start > /dev/null 2>&1 < /dev/null &
> 
> If it is started like that the PID is changing and Systemd does not know about PID and it is not manageable by systemctl anymore.
> I would change now to let user postgres run systemctl and check if it is working then. But just wonder if anyone had that problem too and knows how to fix.
> 
> Mit herzlichen Grüßen
> 
> Mathias Buresch
> Systems Engineer
> --
> mathias.buresch at de.clara.net
> Tel: +49 (69) 40 80 18 - 265
> Fax: +49 (69) 40 80 18 - 129
> 
> Claranet GmbH
> Hanauer Landstraße 196
> 60314 Frankfurt
> 
> Geschäftsführung Olaf Fischer
> Hrb 50381 AG Frankfurt am Main
> Vat-ID de 812918694
> 
> http://www.claranet.de
> 


More information about the pgpool-general mailing list