warm standby - apply wal archives

From: MirrorX <mirrorx(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: warm standby - apply wal archives
Date: 2011-09-05 13:55:41
Message-ID: 1315230941658-4770567.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2011-09-05 14:54:21 Re: Protocol question - fastpath & parameter status 'S'
Previous Message Guillaume Lelarge 2011-09-05 13:08:30 Re: Help for Migration