Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 34B8B9FA0D8 for ; Tue, 28 Aug 2007 10:36:06 -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 07883-05 for ; Tue, 28 Aug 2007 10:36:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 4E1429FA0A2 for ; Tue, 28 Aug 2007 10:35:59 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7SDZvau023288; Tue, 28 Aug 2007 09:35:57 -0400 (EDT) To: Jordi Mulet cc: pgsql-admin@postgresql.org Subject: Re: No restore of BLOB data (permissions?) In-reply-to: <509760.64585.qm@web34415.mail.mud.yahoo.com> References: <509760.64585.qm@web34415.mail.mud.yahoo.com> Comments: In-reply-to Jordi Mulet message dated "Tue, 28 Aug 2007 03:01:46 -0700" Date: Tue, 28 Aug 2007 09:35:57 -0400 Message-ID: <23287.1188308157@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/345 X-Sequence-Number: 26676 Jordi Mulet writes: > 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 = Please fix your mailer to not mangle text like that ... Anyway. I'm wondering about version skew. What PG version is this, and in particular are the pg_restore and server the same version? What shows up in the postmaster log when this happens? regards, tom lane