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@xxxxxx>
Reply-To: isk <isk@xxxxxx>
To: pgsql-admin@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxxx 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
