Thread: Re: PITR for replication?

Andrew,

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

I believe that Command Prompt's "Mammoth Replicator" works on something like 
log shipping.    There are both advantages and disadvantages to the approach, 
meaning that we will still need other replication strategies, like Slony and 
DBMirror.

Also, the jump from PITR --> Log Shipping is not a trivial one.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

On Fri, Apr 02, 2004 at 08:47:09AM -0800, Josh Berkus wrote:

> I believe that Command Prompt's "Mammoth Replicator" works on something like 
> log shipping.    There are both advantages and disadvantages to the approach, 
> meaning that we will still need other replication strategies, like Slony and 
> DBMirror.

I wonder what would you use DBMirror for once Slony-I is complete?

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El destino baraja y nosotros jugamos" (A. Schopenhauer)