Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BFBA99FB55E for ; Wed, 11 Apr 2007 13:28:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 08913-05 for ; Wed, 11 Apr 2007 13:28:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.equipoint.com (mail.equipoint.com [198.145.191.99]) by postgresql.org (Postfix) with ESMTP id 787AF9FB88A for ; Wed, 11 Apr 2007 13:28:47 -0300 (ADT) Received: from [192.168.120.97] ([67.108.63.204]) by mail.equipoint.com (Merak 8.9.1) with ASMTP id QUI96440 for ; Wed, 11 Apr 2007 09:23:40 -0700 Message-ID: <461D0C11.4030400@equipoint.com> Date: Wed, 11 Apr 2007 09:25:53 -0700 From: Sean Murphy User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Best compressed archive_command on Linux? X-Enigmail-Version: 0.94.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/100 X-Sequence-Number: 25164 I'm in the process of moving an 8.2 server from Win32 to Ubuntu Linux. On Win32, I implemented WAL archiving with the archive_command "rar a -ep -m5 -s -t -dh w:/%f.rar %p" Anyway, I'm going to use WAL archiving on the new server, and need the files to be compressed. My first inclination is to use "tar -czf /walarchive/%f.tar.gz %p > /dev/null" Before I go with that, though, I was wondering if anybody had any specific experience / advice with a better command, reasons why this command might fail zero or succeed nonzero, or additional/different options for tar that would yield better results. Thanks, Sean