03.07.2013, 11:42, "Stefano Sasso" <stesa...@gmail.com>:
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. 
 
This is understandable, it is not clear what your "slave" is different from "standby".
 
 
 
 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

_______________________________________________
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

Reply via email to