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 [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
