Skip site navigation (1) Skip section navigation (2)

BUG #2727: pg_restore error on BLOB COMMENTS

From: "Konstantin Pelepelin" <cat(at)dtf(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2727: pg_restore error on BLOB COMMENTS
Date: 2006-10-31 18:04:36
Message-ID: 200610311804.k9VI4a04027253@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2727
Logged by:          Konstantin Pelepelin
Email address:      cat(at)dtf(dot)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

Responses

pgsql-bugs by date

Next:From: Jeff DavisDate: 2006-10-31 19:29:49
Subject: Re: COPY fails on 8.1 with invalid byte sequences in text
Previous:From: Ivan VolfDate: 2006-10-31 17:49:49
Subject: BUG #2726: reindex database failed if number is in database name

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group