Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D558D2E0033 for ; Mon, 18 Feb 2008 14:19:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31666-05 for ; Mon, 18 Feb 2008 14:19:33 -0400 (AST) Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.179]) by postgresql.org (Postfix) with ESMTP id D5ABB2E0030 for ; Mon, 18 Feb 2008 14:19:33 -0400 (AST) Received: by el-out-1112.google.com with SMTP id r27so1008519ele.5 for ; Mon, 18 Feb 2008 10:19:32 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=shaS6tOIq6PslnDiT2rcWYhZoQcEbzb5NQHea60a8LA=; b=n/X3pU7Zp5vF9tYxI51PnfAUV3+RI4yEzOJX7KatMPs/Np1mc9LN5P4jCN4PnEGaeACQpq7F0I/aNw+5uVThAw6H2cWg5t949o7RM2d0lfdKfE9ItjP3GLlAvlmkWA36aOmrxjbHGNXzQK01d3aM703pVX2nCJqTeYHv6VQenuE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BqVmRYJ/jSNdFaDKvIg1eXc1VPTOP1v+uleO0t8kUsWDnbtwUzORQZ2CleVnvp0HHpOkh79NTG/6Ldd+uoLbdljonOfTidP4mdCF1BOSYH46SUzgVO9TouaZ2t9txZrZGA50fXlO1qYROMQgfxrmmnq5nVwLywyJTLRa8d4w67E= Received: by 10.142.128.6 with SMTP id a6mr4572778wfd.135.1203358772049; Mon, 18 Feb 2008 10:19:32 -0800 (PST) Received: by 10.142.185.11 with HTTP; Mon, 18 Feb 2008 10:19:32 -0800 (PST) Message-ID: <5a9699850802181019k4a17cdaapa6c4564f9e569165@mail.gmail.com> Date: Mon, 18 Feb 2008 20:19:32 +0200 From: "Brian Modra" To: "Vladimir Rusinov" Subject: Re: WAL backups Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <5a9699850802180140ifba5ddeo29b652a87b793e59@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/195 X-Sequence-Number: 28269 On 18/02/2008, Vladimir Rusinov wrote: > > > On 2/18/08, Brian Modra wrote: > > 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. > > 1. Setup a key-based authentification in ssh > > 2. > archive_command = "scp %f user@remoteserver:/home/backups/" > restore_command = "scp user@remoteserver:/home/backups/%f %d" > > (not sure about %f and %d - too lazy to read manual) Thats pretty much what I'm doing already but the problem is that I'm quickly running out of disk space on the remote server. > > -- > Vladimir Rusinov > Voronezh, Russia > UNIX Admin @ Murano Software -- 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