Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 46CCC650EA0 for ; Tue, 24 Jun 2008 03:47:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87428-01 for ; Tue, 24 Jun 2008 03:46:53 -0300 (ADT) X-Greylist: delayed 00:05:13.474352 by SQLgrey-1.7.6 Received: from mail.careerjunction.co.za (mail.careerjunction.co.za [196.35.3.13]) by postgresql.org (Postfix) with ESMTP id 88987650E23 for ; Tue, 24 Jun 2008 03:46:50 -0300 (ADT) Received: from [172.19.44.59] (59-44-19-172.careerjunction.local [172.19.44.59]) by mail.careerjunction.co.za (8.13.8/8.13.8/SuSE Linux 0.8) with ESMTP id m5O6fIJi022979 for ; Tue, 24 Jun 2008 08:41:21 +0200 Message-ID: <4860970E.9070305@careerjunction.co.za> Date: Tue, 24 Jun 2008 08:41:18 +0200 From: Adrian Moisey User-Agent: Thunderbird 2.0.0.14 (X11/20080505) MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: replication Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.899 tagged_above=0 required=5 tests=FS_REPLICA=1.179, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200806/793 X-Sequence-Number: 134322 Hi We have a 100GB database (16GB dumped) running on 8.2. Since the bandwidth in South Africa isn't that freely available it is difficult for us to get a new copy of out DB in our office (our fastest link in the office is 4Mbps). What can you recommend for me to get an up to date copy of my DB in the office with as little transfer as possible. A few ideas I've been toying with are rsyncing a dump of the db, or replication. Any ideas? -- Adrian Moisey Systems Administrator | CareerJunction | Your Future Starts Here. Web: www.careerjunction.co.za | Email: adrian@careerjunction.co.za Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842