Re: Continuous PITR (was Re: multimaster)

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!