Re: streaming replication - Mailing list pgsql-admin

From Scott Ribe
Subject Re: streaming replication
Date
Msg-id 8CC5F53E-1D02-43DE-8198-D2BB9297173E@elevated-dev.com
Whole thread Raw
In response to Re: streaming replication  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: streaming replication  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
On Nov 7, 2011, at 10:10 AM, Kevin Grittner wrote:

> If the bottleneck is the network, be sure that you are using a
> daemon on the remote side; otherwise you do drag all the data over
> the wire for any file which doesn't have an identical timestamp and
> size.  An example of how to do that from the rsync man page:
>
> rsync -av -e "ssh -l ssh-user" rsync-user@host::module /dest
>
> This will try to identify matching portions of files and avoid
> sending them over the wire.

??? The normal way of using will using rolling checksums rather than sending all the data over the network:

rsync -av rsync-user@host:/source /dest

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: pg_dump from 8.4 to 8.3
Next
From: "Kevin Grittner"
Date:
Subject: Re: streaming replication