time lag on replication is considered bad and thus avoided like the plague.<br><br>However, it can be done by a scripted write-ahead log migration so that only the logs from 30 minutes ago are processed.<br><br>you might want to look at techniques for using WAL and roll back. The idea is the keep things as close to in-sync as possible but use the WALs to back out of a wrong commit.<br>
<br>NOTE: by using atomic transactions you will not get corrupt data unless the logic flow around the insertion is bad. You can get incorrect data. As PostgreSQL performs extensive type-checking on inserts, the corrupt issue is moot. Unless all fields are text...<br>
<br><div class="gmail_quote">On Mon, Dec 19, 2011 at 11:17 AM, Wolf Halton <span dir="ltr"><<a href="mailto:wolf.halton@gmail.com">wolf.halton@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
A month ago I was talking to Jim Kinney about PostgreSQL replication, but I can't remember if we got down to specifics of how to make PostgreSQL hot spare take a 30-minute lag to its write. The stuff I am seeing all looks like the kind of feature most people are looking for is 1:1 realtime synced hot-spare. I want an offset so if the data is corrupt, it might be possible to recover on main before the hot-spare data is also corrupt.<br>
<br>I have been noodling around on the PostgreSQL site all morning and nobody seems to have that piece there.<span class="HOEnZb"><font color="#888888"><br><br><br clear="all"><br>-- <br>This Apt Has Super Cow Powers - <a href="http://sourcefreedom.com" target="_blank">http://sourcefreedom.com</a><br>
Advancing Libraries Together - <a href="http://LYRASIS.org" target="_blank">http://LYRASIS.org</a><br><br>
</font></span><br>_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>-- <br>James P. Kinney III<br><br>As long as the general population is passive, apathetic, diverted to
consumerism or hatred of the vulnerable, then the powerful can do as
they please, and those who survive will be left to contemplate the
outcome.<br>- <i><i><i><i>2011 Noam Chomsky<br><br><a href="http://heretothereideas.blogspot.com/" target="_blank">http://heretothereideas.blogspot.com/</a><br></i></i></i></i><br>