Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A26979F931D for ; Tue, 28 Aug 2007 07:01:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32919-07 for ; Tue, 28 Aug 2007 07:01:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web34415.mail.mud.yahoo.com (web34415.mail.mud.yahoo.com [66.163.178.164]) by postgresql.org (Postfix) with SMTP id 12E5C9F957F for ; Tue, 28 Aug 2007 07:01:47 -0300 (ADT) Received: (qmail 66738 invoked by uid 60001); 28 Aug 2007 10:01:46 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=T5zWUAN02CcWzMLUUMHuIUv2Z7IKLss83qJcMYh6r01j8C2719TSAYt14gAtyoh0usGAGrIVAAzVjfCuz1G7R7aVwp82GgUI/fyupToBNOCaXOcc+ALrFx0OywfmPMqEBPg7xDVeKDNcHKsylT4zwDLtgl5sHmK5rbWMOvIqmJE=; X-YMail-OSG: r.B9lOcVM1mvuhZsOZmvyvYQt0TEjQm757vQyFXIX4CVPBy5qggfHctD5dOTFkKSbRrcV_wnuFgV0v5XnzC0f9qj1qft5TMJqL7Ip.YMnRlmkEc87N_K2YGP7ATc1g-- Received: from [209.191.119.133] by web34415.mail.mud.yahoo.com via HTTP; Tue, 28 Aug 2007 03:01:46 PDT X-Mailer: YahooMailRC/651.48 YahooMailWebService/0.7.119 Date: Tue, 28 Aug 2007 03:01:46 -0700 (PDT) From: Jordi Mulet Subject: No restore of BLOB data (permissions?) To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-822765396-1188295306=:64585" Message-ID: <509760.64585.qm@web34415.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/343 X-Sequence-Number: 26674 --0-822765396-1188295306=:64585 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Hi,=0A 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).=0AMessage.=0A= pg_restore -c -h localhost -p 5432 -U postgres -d database1 -v database1.b= ackup=0A=0Apg_restore: restoring BLOBS=0Apg_restore: [archiver] could not c= reate large object 16591=0Apg_restore: *** aborted because of error=0A=0Apg= _dump.exe -h localhost -p 5432 -U postgres -v -o -F c -b database1 -f "da= tabase1.backup"=0A=0Adatabase1.backup is created (aprox. 25 MB)=0A=0Aerror = code 0=0A=0AI tried pg_restore -l in order to list contents of backup fil= e and it seems some problem is detected on database1.backup:=0A=0A1690; 0 0= BLOBS - BLOBS =0A1691; 0 0 BLOB COMMENTS - BLOB COMMENTS=0A=0A=0A = =0A________________________________________________________________________= ____________=0ABe a better Globetrotter. Get better travel answers from som= eone who knows. Yahoo! Answers - Check it out.=0Ahttp://answers.yahoo.com/d= ir/?link=3Dlist&sid=3D396545469 --0-822765396-1188295306=:64585 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable
Hi,
=0A
 I tried to backup and restore a database&n= bsp; (including blob data) and pg_restore give me an error (pg_dump se= ems to be working Ok).
=0A
Message.
=0A
pg_restore  = -c -h localhost -p 5432 -U postgres -d database1 -v database1.backup=0A
 
=0A
pg_restore: restoring BLOBS
pg_restore: = [archiver] could not create large object 16591
pg_restore: *** aborted b= ecause of error
=0A
 
=0A
pg_dump.exe -h localhost -= p 5432 -U postgres -v -o -F c -b  database1 -f  "database1.b= ackup"
=0A
 
=0A
database1.backup is created (aprox.= 25 MB)
=0A
 
=0A
error code 0
=0A
 =0A
I tried  pg_restore -l  in order to list content= s of backup file and it seems some problem is detected on database1.backup:=
=0A
 
=0A
1690; 0 0 BLOBS - BLOBS
1691; 0 0 BLO= B COMMENTS - BLOB COMMENTS

=0A
Looking fo= r a deal? Find great prices on flights and hotels with Yahoo!= FareChase. --0-822765396-1188295306=:64585--