Hi, I am using pgpool-II in raw mode to support failover between two backends. master/slave, load_balancing, replication and connection cache are all set to off. Databases are replicated using streaming replication, however we just need simple failover between databases as database failover is to be initiated manually.
failover_on_backend_error is set to on and both backends are configured with default flag ALLOW_TO_FAILOVER set. Once backend0 (master) is down, pgpool failovers without any problems to standby, leaving backend0 in status 3. After master is brought back again, backend0 is not automatically reattached and it is impossible to re-attach it manually using pcp_attach_node command. My questions: - does raw mode support automatic backend re-attach at all? - why is it not possible to reattach node manually using pcp_attach node command? Attached is the configuration file Best Regards, Nenad
pgpool.conf
Description: Binary data
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
