Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0B9819FB46C for ; Fri, 2 Mar 2007 06:52:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 32021-10 for ; Fri, 2 Mar 2007 06:52:28 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from xgate.rdw.ru (xgate.rdw.ru [213.219.232.34]) by postgresql.org (Postfix) with ESMTP id 308589FB460 for ; Fri, 2 Mar 2007 06:52:30 -0400 (AST) Received: (qmail 1578 invoked from network); 2 Mar 2007 10:52:27 -0000 Received: from senoval.rdw.ru ([192.168.0.57]) (envelope-sender ) by xgate.rdw.ru (qmail-ldap-1.03) with DES-CBC3-SHA encrypted compressed SMTP for ; 2 Mar 2007 10:52:27 -0000 Received: (qmail 6496 invoked from network); 2 Mar 2007 10:52:26 -0000 Received: by simscan 1.2.0 ppid: 6486, pid: 6492, t: 0.0182s scanners:none Received: from mmx.rdw.ru ([192.168.22.117]) (envelope-sender ) by senoval.rdw.ru (qmail-ldap-1.03) with SMTP for ; 2 Mar 2007 10:52:26 -0000 Date: Fri, 2 Mar 2007 13:52:36 +0300 From: isk X-Mailer: The Bat! (v3.5) UNREG / CD5BF9353B3B7091 Reply-To: isk Organization: RDW X-Priority: 3 (Normal) Message-ID: <3610194854.20070302135236@rdw.ru> To: pgsql-admin@postgresql.org Subject: Problem with pg_restore MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.97 tagged_above=0 required=5 tests=AWL, BAYES_60, SPF_HELO_PASS, SPF_PASS X-Spam-Level: ** X-Archive-Number: 200703/8 X-Sequence-Number: 24832 PostgreSQL version 8.1.4 Linux version 2.6.19-gentoo-r5 (gcc version 4.1.1 (Gentoo 4.1.1)) I make backup with commang: pg_dump -U postgres -h /tmp -Ft -b -C mydb > file.tar When I want to restore from backup, i give error. pg_restore -U postgres -d template1 -v -C < file.tar error report: Command was: COPY sl_log_2 (log_origin, log_xid, log_tableid, log_actionseq, log_cmdtype, log_cmddata) FROM stdin; pg_restore: [tar archiver] corrupt tar header found in 119 (expected 100, computed 40443) file position 4296575488 pg_restore: *** aborted because of error