Re: replication

On Wed, Jun 25, 2008 at 01:52:00PM +0200, Allan Kamau wrote:
> Initially you may want to get the full dump (this applies also to the
> replication option) across to your other site.

Most of the replication systems I've seen require that _they_ send the
data to the remote site, so copying the data yourself is actually a
waste of bandwidth, since it's all going to get copied anyway.  (They
have to do this because that's how they know that they're starting
from a point in time for which they have consistency information.)

You can indeed save on bandwith, however, by tunnelling your postgres
connections through an ssh tunnel that's using compression.

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/