Problem with pg_restore

From: isk <isk(at)rdw(dot)ru>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem with pg_restore
Date: 2007-03-02 10:52:36
Message-ID: 3610194854.20070302135236@rdw.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2007-03-02 11:38:06 Re: Problem with pg_restore
Previous Message Tom Lane 2007-03-02 06:12:13 Re: [SQL] pg_dump error