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.