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

From Ron Johnson
Subject Re: Continuous PITR (was Re: multimaster)
Date
Msg-id 466099B1.1040508@cox.net
Whole thread Raw
In response to Re: Continuous PITR (was Re: multimaster)  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
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
> someone reported doing it already.)

 From within PG, or "manually"?

>> 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?

I wasn't sure whether they were a special case or not.

--
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!


pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Slightly OT.
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Slightly OT.