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
