pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: isk <isk@rdw.ru>
To: pgsql-admin@postgresql.org
Subject: Problem with pg_restore
Date: Fri, 2 Mar 2007 13:52:36 +0300
Message-ID: <3610194854.20070302135236@rdw.ru> (raw)

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




view thread (6+ messages)  latest in thread

Message-ID: <3610194854.20070302135236@rdw.ru>
Permalink:  ../3610194854.20070302135236@rdw.ru/
Also on:    postgresql.org/message-id/3610194854.20070302135236@rdw.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: isk@rdw.ru
  Subject: Re: Problem with pg_restore
  In-Reply-To: <3610194854.20070302135236@rdw.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox