The following bug has been logged online: Bug reference: 2727 Logged by: Konstantin Pelepelin Email address: cat@dtf.ru PostgreSQL version: 8.1.5 Operating system: RHEL4 Description: pg_restore error on BLOB COMMENTS Details: I think, it is part of bug #2452 ( http://archives.postgresql.org/pgsql-bugs/2006-05/msg00113.php ), it is not fixed in 8.1.5 $ pg_restore -v -U postgres -d mydb --disable-triggers -S postgres mydb.tar ... pg_restore: restoring large object OID 70380132 pg_restore: restored 5116 large objects pg_restore: restoring BLOB COMMENTS pg_restore: [tar archiver] could not find header for file 2004.dat in tar archive pg_restore: *** aborted because of error $ pg_restore -l mydb.tar |grep 2004 2004; 0 0 BLOB COMMENTS - BLOB COMMENTS 2004.dat exists in archive and consists of single LF Workaround: (pg_restore -l $DBFILE | fgrep -v '0 0 BLOB COMMENTS - BLOB COMMENTS' >pg_restore_list.txt) pg_restore -v -U postgres -d $DB --disable-triggers -S postgres -L pg_restore_list.txt $DBFILE rm -f pg_restore_list.txt
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных