Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5661F2E003A for ; Mon, 18 Feb 2008 05:40:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21984-05 for ; Mon, 18 Feb 2008 05:39:57 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 2F6E92E002F for ; Mon, 18 Feb 2008 05:40:02 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d37so2964632pye.29 for ; Mon, 18 Feb 2008 01:40:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=lmEiME8skrlUAGXt045fRyn+a16Jrp3RIUuNdtfgUCA=; b=F62FqriuWGxUEUoDqx6gxXRfZh2gtUe0Dp7I43cCSLNUEfDyUTKaAgb6MQkdtAOCgVWM3QSq+mxAcOcpmnsX12ri4hJOHvlY1EoAVBplVTrqeY+GLQ4oCN1cBKXBWZNF/6JHlo55AgD3pADAcigD3P8j/la6Xu6ALh/Ofl23eMc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=XQ+tbhpDT6EEqt85nK6JqlDPqopzy9BdhxewPNqZEGS2pFRIY6UF3XVhe2HxgiwyCVCATjPSwGGewnkXgkB/Kp/fM0cuQBcJt647r0IO/eHv4VRyi+LZ95mb7bJSWnOQuhp9W+1kmCTDi03heZGp4RqVQ3QDZO44OdrjzTkoRBE= Received: by 10.142.203.13 with SMTP id a13mr1179122wfg.156.1203327600382; Mon, 18 Feb 2008 01:40:00 -0800 (PST) Received: by 10.142.185.11 with HTTP; Mon, 18 Feb 2008 01:40:00 -0800 (PST) Message-ID: <5a9699850802180140ifba5ddeo29b652a87b793e59@mail.gmail.com> Date: Mon, 18 Feb 2008 11:40:00 +0200 From: "Brian Modra" To: pgsql-admin@postgresql.org Subject: WAL backups MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/183 X-Sequence-Number: 28257 Hi, I've only just started doing WAL backups, and so far am not able to keep a running backup due to lack of hardware. Obviously I gzip the WAL fioles, but I'm fast running out of disk space. I have a second standy server with 200GB disk, where I store the compressed WAL files, which quickly fills up. Archiving is difficult simply because the server is in a server room in Johannesburg 1000km away. We pay them to keep the server powered up, safe, and connected. They can slip a DVD into it, but that requires me to book it in advance, and it takes maybe a few hours before they can do it. I want to be able to do historical recoveries to any point in time if necessary. I'm interested to hear from other's about hardware for backup. I'm thinking of a second dedicated server offsite (near me), with a large, large disk. Thanks. Brian -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 183 8059 6 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa