Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D9F449FB9FF for ; Thu, 12 Apr 2007 02:35:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27722-05 for ; Thu, 12 Apr 2007 02:35:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id D537A9FB9C6 for ; Thu, 12 Apr 2007 02:35:28 -0300 (ADT) Received: (qmail 13081 invoked from network); 12 Apr 2007 05:35:26 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;d4dbc0b855a95de76b31b57024964a70; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 12 Apr 2007 05:35:26 -0000 Received: (qmail 32208 invoked by uid 1166); 12 Apr 2007 15:35:23 +1000 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.229558 secs); 12 Apr 2007 05:35:23 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.229558 secs Process 32199) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 12 Apr 2007 15:35:22 +1000 From: "Phillip Smith" To: Subject: Re: Best compressed archive_command on Linux? Date: Thu, 12 Apr 2007 15:35:15 +1000 Organization: Weatherbeeta Pty Ptd Message-ID: <00e101c77cc4$58f2cd50$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <200704111149.52643.ejortegau@cable.net.co> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Importance: Normal X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1176356126.853-13076-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.02/0.07 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/116 X-Sequence-Number: 25180 I experience similar on my nightly backups - tar exits with status '2' = but for the life of me I cannot work out WHAT exit 2 means. It still works = fine, but the non-zero return it just annoying. If you're just compressing (ie, not creating a tar-type archive, just = either GZip (gzip) or BZip2 (bzip2) the WAL files. BZip2 has incredible compression, but at the expense of speed of course. Cheers, ~p -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Eduardo J. Ortega Sent: Thursday, 12 April 2007 02:50 To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Best compressed archive_command on Linux? sometimes tar (gnu tar) exited with nonzero status for no reason on my=20 system... no error msg or anything. I recommend something called star. On Wednesday 11 April 2007, Sean Murphy wrote: > 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 > > ---------------------------(end of = broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq --=20 Eduardo J. Ortega - Linux user #222873=20 "No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus=20 Torvalds ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend *******************Confidentiality and Privilege Notice******************* The material contained in this message is privileged and confidential to the addressee. If you are not the addressee indicated in this message or responsible for delivery of the message to such person, you may not copy or deliver this message to anyone, and you should destroy it and kindly notify the sender by reply email. Information in this message that does not relate to the official business of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall not be liable for direct, indirect or consequential loss arising from transmission of this message or any attachments