Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 4DBCC9FA19A for ; Fri, 9 Feb 2007 21:01:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 96455-08 for ; Fri, 9 Feb 2007 21:01:24 -0400 (AST) X-Greylist: delayed 00:09:47.332395 by SQLgrey-1.7.4 Received: from ironport4.cable.net.co (ironport4.cable.net.co [200.118.0.15]) by postgresql.org (Postfix) with ESMTP id 4B14C9FA197 for ; Fri, 9 Feb 2007 21:01:24 -0400 (AST) Received: from epicac.cable.net.co ([200.118.2.50]) by ironport4.cable.net.co with ESMTP; 09 Feb 2007 19:50:05 +0000 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgoXAP+lzEXIdgIyh2dsb2JhbACDZoptAQEBCA4qkT4BAQE X-IronPort-AV: i="4.13,308,1167609600"; d="scan'208"; a="36236822:sNHT21914137" Received: from dynamic-ip-cr20011869155.cable.net.co ([200.118.69.155]) by epicac.cable.net.co (Sun Java System Messaging Server 6.2-7.06 (built Oct 6 2006)) with ESMTPA id <0JD7005FIA890K00@epicac.cable.net.co> for pgsql-admin@postgresql.org; Fri, 09 Feb 2007 19:43:21 +0500 (GMT) Date: Fri, 09 Feb 2007 19:51:11 -0500 From: "Eduardo J. Ortega" Subject: online tape backup To: pgsql-admin@postgresql.org Message-id: <200702091951.14100.ejortegau@cable.net.co> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Content-disposition: inline User-Agent: KMail/1.9.5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.077 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, INVALID_TZ_GMT X-Spam-Level: ** X-Archive-Number: 200702/139 X-Sequence-Number: 24604 Hi: I'm attempting to set up online backup as described on http://www.postgresql.org/docs/8.1/static/backup-online.html For this, i am following these steps: 1) pg_start_backup 2) tar to my tape device /data/postgresql excluding /data/postgresql/pg_xlog 3) pg_stop_backup 4) delete WAL files under /data/pg_trans_log/ (which is the directory to which archive_command copies my archived WAL files) with name "smaller" than the name of the last 000*.backup 5) append to previously created tar on the tape the WAL directory /data/pg_trans_log/ So, you see, i run tar 2 times, first for pg data dir, second for wal archive dir. Everything worked OK for about a week. Now the second tar (the one archiving the WAL files) exits with status 2, no errors on stderr. If i check the contents of the tar on the tape, they are wrong. Is there anything wrong with this procedure? Any other approaches to tape backup that do *not* involve using pg_dump (because of database size, dump time and performance issues)? Any help is greatly appreciated. -- Eduardo J. Ortega - Linux user #222873 "No fake - I'm a big fan of konqueror, and I use it for everything." -- Linus Torvalds