[GENERAL] Continuous PITR (was Re: multimaster)

2007-06-01 Thread Ron Johnson
On 06/01/07 11:16, Andrew Sullivan wrote: [snip] My real question in all this is, "What is the problem you are trying to solve?" Hot failover using combinations of hardware and software, and a disk array that can be mounted across two machines, is actually probably good enough for most cases, a

Re: [GENERAL] Continuous PITR (was Re: multimaster)

2007-06-01 Thread Andrew Sullivan
On Fri, Jun 01, 2007 at 03:58:01PM -0500, Ron Johnson wrote: > What you need are disk blocks to be mirrored to a machine at the DR > site. Or "continuous PITR" to the DR machine. I thought you could already do this? (I'm not, but I was pretty sure someone reported doing it already.) > This the

Re: [GENERAL] Continuous PITR (was Re: multimaster)

2007-06-01 Thread Ron Johnson
On 06/01/07 16:25, Andrew Sullivan wrote: On Fri, Jun 01, 2007 at 03:58:01PM -0500, Ron Johnson wrote: What you need are disk blocks to be mirrored to a machine at the DR site. Or "continuous PITR" to the DR machine. I thought you could already do this? (I'm not, but I was pretty sure someon

Re: [GENERAL] Continuous PITR (was Re: multimaster)

2007-06-01 Thread Greg Smith
On Fri, 1 Jun 2007, Ron Johnson wrote: How difficult would it be to modify the process (the postmaster?) that writes the xlogs(?) to tee them to a listening process across the cloud on the DR machine, which then applies them to the DR database? On an 8.2 server, you can practically do this ri

Re: [GENERAL] Continuous PITR (was Re: multimaster)

2007-06-03 Thread Scott Ribe
> P.S. it's not the "the cloud" anymore, it's "the tubes". It was always tubes. The cloud was just a convenient simplification for the technically declined ;-) -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---(end of broadcast)---