<div dir="ltr">Hello,<div><br></div><div>I am trying to configure Postgres 9.3 HA Cluster that consists of 2..5 servers. Our system is read-heavy with rare writes. The data must be consistent over all servers, therefore we have decided to use pgpool's replication functionality.</div>
<div><br></div><div>As for HA, I followed tutorial: <a href="http://pgpool.projects.pgfoundry.org/contrib_docs/pgpool-II_for_beginners.pdf">http://pgpool.projects.pgfoundry.org/contrib_docs/pgpool-II_for_beginners.pdf</a><br>
</div><div><br></div><div>I have a question regarding the 2nd recovery stage "pgpool_recovery_pitr". Don't we need to perform "psql -c 'select pg_switch_xlog()' postgres" on the host and then copy it over to the failed node?</div>
<div><br></div><div>PS. It is a good decision to use pgpool replication+recovery? </div><div><div><br></div><div>Thank you!</div><br>Best Regards,<br>Gintautas Sulskus
</div></div>