Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C69349FA14E for ; Thu, 23 Aug 2007 02:18:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21062-09 for ; Thu, 23 Aug 2007 02:18:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 7060D9F9FE0 for ; Thu, 23 Aug 2007 02:18:27 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7N5IOOo017439; Thu, 23 Aug 2007 01:18:24 -0400 (EDT) To: Bruce Momjian cc: Tena Sakai , Kenneth Marshall , Kevin Grittner , pgsql-admin@postgresql.org Subject: Re: tar, but not gnu tar In-reply-to: <200708230422.l7N4MLk22375@momjian.us> References: <200708230422.l7N4MLk22375@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Thu, 23 Aug 2007 00:22:21 -0400" Date: Thu, 23 Aug 2007 01:18:24 -0400 Message-ID: <17438.1187846304@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/284 X-Sequence-Number: 26615 Bruce Momjian writes: > Tena Sakai wrote: >> I had a bit of time to experiment with tar and star today >> and I am no longer sure what the real issue is. Perhaps >> some of you can clarify. Here's the test I ran: > I don't think 'touch' is enough for tar to see the file as changed (you > are only updating metadata). (tar did complain but the file contents > didn't so it is hard to say if that is a good test.) You should change > the file contents during the backup. In fact, I'll bet that you have to change the file *length* during the backup to trigger gnu tar's complaint. If it were rigorously checking for file content change, it'd have to read the whole of every file twice, which hardly seems like overhead that anyone would accept. But a check for length change would just mean one extra stat() call per file, which is a whole lot more plausible. regards, tom lane