X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 458E79DD77F for ; Fri, 2 Dec 2005 20:47:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 17284-05 for ; Fri, 2 Dec 2005 20:47:07 -0400 (AST) X-Greylist: delayed 03:12:16.425124 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id D8EAF9DCAD7 for ; Fri, 2 Dec 2005 20:47:08 -0400 (AST) Received: from smtprelay02.uni-oldenburg.de (smtprelay02.uni-oldenburg.de [134.106.40.86]) by svr2.postgresql.org (Postfix) with ESMTP id 40379F0B7E for ; Fri, 2 Dec 2005 21:34:52 +0000 (GMT) Received: from mailgate.uni-oldenburg.de (mailgate.uni-oldenburg.de [134.106.87.6]) by smtprelay02.uni-oldenburg.de (8.12.11/8.12.11) with ESMTP id jB2LYj7J031110 for ; Fri, 2 Dec 2005 22:34:46 +0100 (envelope-from zac@uni-oldenburg.de) Received: from Gremmlin (gremmlin.physik.uni-oldenburg.de [134.106.236.245]) (authenticated bits=0) by mailgate.uni-oldenburg.de (8.12.11/8.12.11) with ESMTP id jB2LYji7025027 for ; Fri, 2 Dec 2005 22:34:45 +0100 Message-ID: X-Mailer: XFMail 1.5.3 on Linux X-Priority: 3 (Normal) Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit MIME-Version: 1.0 Date: Fri, 02 Dec 2005 22:34:45 +0100 (CET) Organization: Intergalaktischer Denk-Service From: zac@uni-oldenburg.de To: pgsql-admin@postgresql.org Subject: Corrupted dumpfiles X-PMX-Version: 4.7.1.128075, Antispam-Engine: 2.0.3.1, Antispam-Data: 2005.12.2.24 X-PerlMx-Spam: Gauge=IIIIIII, Probability=7%, Report='NO_REAL_NAME 0, __C230066_P5 0, __CT 0, __CTE 0, __CT_TEXT_PLAIN 0, __HAS_MSGID 0, __HAS_X_MAILER 0, __HAS_X_PRIORITY 0, __MIME_TEXT_ONLY 0, __MIME_VERSION 0, __SANE_MSGID 0' X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.55 required=5 tests=[NO_REAL_NAME=0.55] X-Spam-Score: 0.55 X-Spam-Level: X-Archive-Number: 200512/20 X-Sequence-Number: 19740 Hi, due a error in the crontab i have the problem that the dump files are "overlapping". That means before the dump process was finished a second pg_dump started. Therefor i have some dump files but non of them holds the whole content. If i try to reload the dumpfiles pg_restore stopps after some bytes (there are much more in the dump file). Do someone know a tool with one can fix the dump fliles so that i can rescue most of the data ?? Every help wold greatly appreciated. Norbert -- =============================================================================== *Dipl.Phys. Norbert Zacharias zac@uni-oldenburg.de* *FB Physik Norbert.Zacharias@arbi.informatik.uni-oldenburg.de* *Carl-von-Ossietzky-Universitaet Tel. 0049-441-7983530* *Postfach 2503 FAX 0049-441-7983990* *26111 Oldenburg * *Was Du nicht willst das man Dir tu, das will auch nicht was willst denn Du? * *Heinz Erhardt * ===============================================================================