Continuous PITR (was Re: multimaster)

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, assuming it is implemented
> correctly (see recent discussion on this topic). So the availability
> piece is mostly solved. What else do you want?

What you need are disk blocks to be mirrored to a machine at the DR
site. Or "continuous PITR" to the DR machine.

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?

This then begs the question: are CREATE|ALTER TABLESPACE commands
stored in the xlogs?

--
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!