03.07.2013, 12:30, "Stefano Sasso" <stesa...@gmail.com>:
2013/7/3 Andrey Groshev <gre...@yandex.ru>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".slave is syncronized with streaming replication,standby do a sync on daily basis (so if both master and slave fails, I lose only one day of data - not a problem).
I would call it a "backup" :)
,--we can assume that only one host fails at a time, so I have no problem if the new slave takes log time to resync with the master.they have a dedicated GB link for clustering, and the database average size will be 10 Gb
Stefano Sasso
http://stefano.dscnet.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
_______________________________________________ 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