pg.ddx.io  pgsql-hackers-pitr@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Greg Stark <gsstark@mit.edu>
To: pgsql-hackers@postgresql.org
Subject: Re: PITR for replication?
Date: 01 Apr 2004 23:33:23 -0500
Message-ID: <87isgjov70.fsf@stark.xeocode.com> (raw)
In-Reply-To: <1080867508.29882.8.camel@localhost.localdomain>
References: <KGEFLMPJFBNNLNOOOPLGKEEHCHAA.simon@2ndquadrant.com>
	<5674.1080750914@sss.pgh.pa.us>
	<406B6EDB.5040406@familyhealth.com.au>
	<1080867508.29882.8.camel@localhost.localdomain>


"J. Andrew Rogers" <jrogers@neopolitan.com> writes:

> I may be completely missing the point here, but it looks to me as though
> the PITR archival mechanism is also most of a native replication
> facility.  Is there anyone reason this couldn't be extended to
> replication, and if so, is anyone planning on using it as such?
> 
> My memory is fuzzy on this point, but I seem to recall that this is
> (was?) how replication is more-or-less done for many of the big
> commercial RDBMS.

Well "replication" is one of those things that means different things to
different people. IMHO, this is one of the simpler, more reliable, mechanisms
and would be nice to have. And you're right that it shouldn't require much
more work, in fact it's probably easier than a lot of other cases that PITR
requires.

For a long time Oracle has supported this mechanism for running warm standby
databases. Basically you maintain a second database and every time an archived
log is finished you ship it over and immediately "restore" it on the standby
machine. Whenever you have a failure you can quickly fail over to the standby
database which is all ready to go and up-to-date within minutes of your
failure.

Since 8i Oracle has also supported a more advanced version where you can open
the standby database in read-only mode. This makes it useful for running batch
reports and so on. In postgres this wouldn't work nearly so well since even
read-only queries require write access to the database in postgres. Perhaps
it's not nearly so urgent since running long-running batch queries on a busy
system in postgres doesn't pose all the same dangers it does in Oracle (the
dreaded "snapshot too old" error) -- though there are other analogous dangers
(fsm settings being too small unexpectedly).

-- 
greg




view thread (5+ messages)  latest in thread

Message-ID: <87isgjov70.fsf@stark.xeocode.com>
Permalink:  ../87isgjov70.fsf@stark.xeocode.com/
Also on:    postgresql.org/message-id/87isgjov70.fsf@stark.xeocode.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-hackers-pitr@postgresql.org
  Cc: gsstark@mit.edu, pgsql-hackers@postgresql.org
  Subject: Re: PITR for replication?
  In-Reply-To: <87isgjov70.fsf@stark.xeocode.com>
  References: <KGEFLMPJFBNNLNOOOPLGKEEHCHAA.simon@2ndquadrant.com> <5674.1080750914@sss.pgh.pa.us> <406B6EDB.5040406@familyhealth.com.au> <1080867508.29882.8.camel@localhost.localdomain> <87isgjov70.fsf@stark.xeocode.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox