Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 949FD632FB3 for ; Fri, 12 Mar 2010 12:46:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 85491-05 for ; Fri, 12 Mar 2010 16:46:19 +0000 (UTC) X-Greylist: delayed 00:05:35.143524 by SQLgrey-1.7.6 Received: from mail.netmail.com.cy (mail.netmail.com.cy [82.102.64.39]) by mail.postgresql.org (Postfix) with ESMTP id 0F3DF632793 for ; Fri, 12 Mar 2010 12:46:19 -0400 (AST) Received: from mail.magneta.com.cy (mail.magneta.com.cy [82.102.77.57]) by mail.netmail.com.cy (Postfix) with ESMTP id AF1D01A26513 for ; Fri, 12 Mar 2010 18:41:02 +0200 (EET) Received: from [10.1.1.244] (unknown [10.1.0.2]) by mail.magneta.com.cy (Postfix) with ESMTPSA id 2F0C0A5603 for ; Fri, 12 Mar 2010 18:40:41 +0200 (EET) Message-ID: <4B9A6E8B.4050303@magneta.com.cy> Date: Fri, 12 Mar 2010 18:40:43 +0200 From: Nicos Panayides User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.8) Gecko/20100227 Lightning/1.0b1 Thunderbird/3.0.3 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Off-site storage for PITR logs 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=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/79 X-Sequence-Number: 33878 Hi, I am planning an off-site backup solution for a fairly busy (mostly-write) 8.3 database. The database is currently about 200GB in size. I though about using log shipping and cold standby since it's easy in terms of administration and also offers point in time recovery. The database generates about 3 PITR log files per minute. If my calculations are correct the sites need to be connected with a 7MBit connection and the logs will need about 68GB of storage per day! Does anyone have any suggestions on how to significantly reduce the volume of log files or recommend another off-site backup solution that would require less bandwidth and storage? Thanks. -- Regards, Nicos Panayides IT Manager Magneta Technologies Ltd Tel: +357 22721919, 22317400 Fax: +357 22721917 Web: http://www.magneta.eu