Hi, I've a pgpool-II replication + load balance environment with seven backend servers running PostgreSQL 8 and CentOS 5.
The backend 0 (master node) runs both pgpool-II and PostgreSQL. I'm setting up online recovery with rsync using the same script for both 1st and 2nd stage commands. Considering a scenario where the backend 0 (which runs pgpool-II and PostgreSQL) PostgreSQL is disconnected from pgpool-II, I have the following questions: * How online recovery is supposed to work in this case? * Do I need to have pgpool-II installed on all backend servers? If so, I will have dummy pgpool-II processes running on backend serves just to have the pgpool communication manager running and be able to run pcp_recovery_node from another backend? * How 2nd stage of online recovery is supporsed to work if I am recovering from a different backend than the one running pgpool-II and PostgreSQL will continue accepting connections? Is cascading pgpool-II connections to the backend servers a correct solution or workaround here? Best regards,
signature.asc
Description: This is a digitally signed message part
_______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
