Обсуждение: Problem with pg_restore

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

On Freitag, 2. März 2007 11:52 isk wrote:
> corrupt tar header found

I'd say your hardware is broken, either memory problem or disk problem.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:        "curl -s http://zmi.at/zmi4.asc | gpg --import"
// Fingerprint: EA39 8918 EDFF 0A68 ACFB  11B7 BA2D 060F 1C6F E6B0
// Keyserver: www.keyserver.net                   Key-ID: 1C6FE6B0

pg_restore -U postgres -d template0 -v -C < file.tar

try using this command
pg_dump  -U postgres -h /tmp -o -Ft -b -C mydb > file.tar

>From: isk <isk@rdw.ru>
>Reply-To: isk <isk@rdw.ru>
>To: pgsql-admin@postgresql.org
>Subject: [ADMIN] Problem with pg_restore
>Date: Fri, 2 Mar 2007 13:52:36 +0300
>
>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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly

_________________________________________________________________
The average US Credit Score is 675. The cost to see yours: $0 by Experian.
http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVERAGE

sl_log_2 !!!??? Do you want to restore slony logs? For why!?


> 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
>