X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EBC6953E02 for ; Fri, 29 Apr 2005 14:04:28 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31943-03 for ; Fri, 29 Apr 2005 17:04:21 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 99C0F53DF0 for ; Fri, 29 Apr 2005 14:04:20 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3TH4J6B006853; Fri, 29 Apr 2005 13:04:19 -0400 (EDT) To: Pallav Kalva Cc: pgsql-admin@postgresql.org Subject: Re: Postges 8.0.2 Online backup Errors! In-reply-to: <42724333.3060708@deg.cc> References: <42724333.3060708@deg.cc> Comments: In-reply-to Pallav Kalva message dated "Fri, 29 Apr 2005 10:22:43 -0400" Date: Fri, 29 Apr 2005 13:04:19 -0400 Message-ID: <6852.1114794259@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/405 X-Sequence-Number: 17418 Pallav Kalva writes: > bash-2.05b$ ./backup.sh b > 17/8E3DA9F0 > tar: tabledata/165899758/165958430: file changed as we read it > tar: Error exit delayed from previous errors > 17/8E8CB0A8 > bash-2.05b$ You may need to use a stupider version of tar that doesn't consider that an error condition. (Offhand I see nothing in the gnu tar man page about suppressing this error check :-() Perhaps cpio would do instead? The problem is not that you have an unusable backup, it is that if your script ignores error exits from tar, you won't be able to detect real problems. regards, tom lane