[ale] OT - Postgresql Hot Spare time-lag config question

Geoffrey Myers lists at serioustechnology.com
Mon Dec 19 11:47:25 EST 2011


Wolf Halton wrote:
> 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.
> 
> I have been noodling around on the PostgreSQL site all morning and 
> nobody seems to have that piece there.

I've played with Postgres replication a few times and to my knowledge, I 
don't know that what you're asking is possible.

> 
> 
> 
> -- 
> This Apt Has Super Cow Powers - http://sourcefreedom.com
> Advancing Libraries Together - http://LYRASIS.org
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo


-- 
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson


More information about the Ale mailing list