Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B0DEE2E005F for ; Mon, 18 Feb 2008 12:26:18 -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 92904-01-5 for ; Mon, 18 Feb 2008 12:26:13 -0400 (AST) Received: from ti-out-0910.google.com (ti-out-0910.google.com [209.85.142.187]) by postgresql.org (Postfix) with ESMTP id E58A52E0041 for ; Mon, 18 Feb 2008 12:25:45 -0400 (AST) Received: by ti-out-0910.google.com with SMTP id y6so982287tia.5 for ; Mon, 18 Feb 2008 08:25:44 -0800 (PST) Received: by 10.110.92.8 with SMTP id p8mr3534243tib.23.1203351944455; Mon, 18 Feb 2008 08:25:44 -0800 (PST) Received: by 10.70.95.13 with HTTP; Mon, 18 Feb 2008 08:25:44 -0800 (PST) Message-ID: Date: Mon, 18 Feb 2008 19:25:44 +0300 From: "Vladimir Rusinov" To: "Brian Modra" Subject: Re: WAL backups Cc: pgsql-admin@postgresql.org In-Reply-To: <5a9699850802180140ifba5ddeo29b652a87b793e59@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_372_13760960.1203351944369" References: <5a9699850802180140ifba5ddeo29b652a87b793e59@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/189 X-Sequence-Number: 28263 ------=_Part_372_13760960.1203351944369 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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) -- Vladimir Rusinov Voronezh, Russia UNIX Admin @ Murano Software ------=_Part_372_13760960.1203351944369 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 2/18/08, Brian Modra <epailty@googlemail.com> 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)

--
Vladimir Rusinov
Voronezh, Russia
UNIX Admin @ Murano Software ------=_Part_372_13760960.1203351944369--