Re: Continuous PITR (was Re: multimaster) - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Continuous PITR (was Re: multimaster)
Date
Msg-id 20070601212550.GP24299@phlogiston.dyndns.org
Whole thread Raw
In response to Continuous PITR (was Re: multimaster)  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Continuous PITR (was Re: multimaster)  (Ron Johnson <ron.l.johnson@cox.net>)
List 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@crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?
        --attr. John Maynard Keynes

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: query log corrupted-looking entries
Next
From: PFC
Date:
Subject: Re: collision in serial numbers after INSERT?