[pgpool-general: 5665] Re: Proper way to use pg_rewind

[Tatsuo Ishii]

> Hi Experts,
> 
> Currently we are using rsync whenever master role is changed between servers.  However, since pg_rewind has changed in postgres 9.5 and 9.6 we would like to use pg_rewind when possible.  Please let us know what is the proper way to use pg_rewind.  How can I know when pg_rewind should not be used (after master crash?) can pgpool assist with that?

I have not tried it but yes, pg_rewind cannot be used after
crash. There's nothing so far Pgpool-II can help in this regard. Once
I thought about teaching Pgpool-II if it's after crash or scheduled
failover. I don't have time to implement it for now though.

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