hello all, i would like your advice in the following matter. If i am not wrong, by implementing a warm standby (pg 8.4) the wal archives are being sent to the fail over server and when the time comes the fail over who already has a copy of the /data of the primary and all the wal archives, starts the recovery process by applying all these wals. and when it has finished, it goes up and is ready for connections. the question i have is the following. what happens if the wal archives are too many? how much could this procedure take? if someone has tested it and has some metrics i would really appreciate to see them. and more than that, is there a way to apply the wals every hour for example? so that when the time comes this procedure doesnt take too long? if i write a script that does the mentioned above, would that work? thx in advance -- View this message in context: http://postgresql.1045698.n5.nabble.com/warm-standby-apply-wal-archives-tp4770567p4770567.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
