Re: Synchronous Log Shipping Replication - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Synchronous Log Shipping Replication
Date
Msg-id 20080915130935.GB3798@alvh.no-ip.org
Whole thread Raw
In response to Re: Synchronous Log Shipping Replication  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Synchronous Log Shipping Replication  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Simon Riggs escribió:

> On Fri, 2008-09-12 at 17:08 +0300, Heikki Linnakangas wrote:

> > > It should be clear that to make this work you must run with a base
> > > backup that was derived correctly on the current master. You can do that
> > > by re-copying everything, or you can do that by just shipping changed
> > > blocks (rsync etc). So I don't see a problem in the first place.
> > 
> > Hmm, built-in rsync capability would be cool. Probably not in the first 
> > phase, though..
> 
> Built-in? Why? I mean make base backup using rsync. That way only
> changed data blocks need be migrated, so much faster.

Why rsync?  Just compare the LSNs ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Transaction Snapshots and Hot Standby
Next
From: "Brendan Jurd"
Date:
Subject: Re: Parsing of pg_hba.conf and authentication inconsistencies