[pgpool-general: 2643] pgpool replication & recovery

[Gintautas Sulskus]

Hello,

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.

As for HA, I followed tutorial:
http://pgpool.projects.pgfoundry.org/contrib_docs/pgpool-II_for_beginners.pdf

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?

PS. It is a good decision to use pgpool replication+recovery?

Thank you!

Best Regards,
Gintautas Sulskus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140321/5e14851c/attachment.html>