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

[Mathias Buresch]

I cannot check that now because other tests are running. But will check that in future and will let you know.

On 05.04.18, 15:34, "Tatsuo Ishii" <ishii at sraoss.co.jp> wrote:

    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
    >