> > Does "standby" mean that PostgreSQL is stopped ? > If Master doesn't have WAL files which new slave needs, > new slave can't connect master. > > How do you solve it ? > copy data or wal-archive on start automatically ? > It may cause timed-out if PostgreSQL has large database.
I'm using streaming replication. 1. First boot > RA compares data and promotes PostgreSQL which has latest data. > The number of comparison can be changed using xlog_check_count parameter. > If monitor interval is 10 sec and xlog_check_count is 360, RA can wait > 1 hour to promote :) I can't wait an hour :) my maximum is 10 minutes :) thanks stefano
_______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
