Re: Continuous PITR (was Re: multimaster)

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Continuous PITR (was Re: multimaster)
Date: 2007-06-01 21:25:50
Message-ID: 20070601212550.GP24299@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 then begs the question: are CREATE|ALTER TABLESPACE commands
> stored in the xlogs?

(I'll spare the rant about begging the question.) Since they're
transactional, they must be, no?

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2007-06-01 21:29:25 Re: collision in serial numbers after INSERT?
Previous Message Alexander Staubo 2007-06-01 21:22:18 Re: Slightly OT.