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

No restore of BLOB data (permissions?)

From: Jordi Mulet <jmuletalbiach(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: No restore of BLOB data (permissions?)
Date: 2007-08-28 10:01:46
Message-ID: 509760.64585.qm@web34415.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,
 I tried to backup and restore a database  (including blob data) and pg_restore give me an error (pg_dump seems to be working Ok).
Message.
pg_restore  -c -h localhost -p 5432 -U postgres -d database1 -v database1.backup

pg_restore: restoring BLOBS
pg_restore: [archiver] could not create large object 16591
pg_restore: *** aborted because of error

pg_dump.exe -h localhost -p 5432 -U postgres -v -o -F c -b  database1 -f  "database1.backup"

database1.backup is created (aprox. 25 MB)

error code 0

I tried  pg_restore -l  in order to list contents of backup file and it seems some problem is detected on database1.backup:

1690; 0 0 BLOBS - BLOBS 
1691; 0 0 BLOB COMMENTS - BLOB COMMENTS


       
____________________________________________________________________________________
Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out.
http://answers.yahoo.com/dir/?link=list&sid=396545469

Responses

pgsql-admin by date

Next:From: Jayakumar_MukundarajuDate: 2007-08-28 10:09:56
Subject: Re: No restore of BLOB data (permissions?)
Previous:From: Dimitri FontaineDate: 2007-08-28 08:03:57
Subject: Re: {Spam} 转发: [ADMIN] Copy cmd error

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