From jmuletalbiach@yahoo.com Tue Aug 28 10:01:59 2007 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-- From Jayakumar_Mukundaraju@satyam.com Tue Aug 28 10:13:49 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BE39A9F99C9 for ; Tue, 28 Aug 2007 07:13:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 23467-07 for ; Tue, 28 Aug 2007 07:13:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hydmail1.satyam.com (hydmail1.satyam.com [124.30.170.13]) by postgresql.org (Postfix) with ESMTP id 98FC19F96A4 for ; Tue, 28 Aug 2007 07:13:40 -0300 (ADT) Received: from hyd.satyam.com (hyd.satyam.com [204.252.161.226]) by hydmail1.satyam.com (8.13.4/8.13.4) with ESMTP id l7SA8aVB005862 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 28 Aug 2007 15:38:36 +0530 Received: from Disclaimerhyd.corp.satyam.ad (hhtbh.satyam.com [172.16.186.212]) by hyd.satyam.com (8.13.1/8.13.1) with ESMTP id l7SA6MsB003806; Tue, 28 Aug 2007 15:36:23 +0530 Received: from hcsmsg002.corp.satyam.ad ([172.16.129.211]) by Disclaimerhyd.corp.satyam.ad with Microsoft SMTPSVC(6.0.3790.211); Tue, 28 Aug 2007 15:42:50 +0530 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.607 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7E95B.FD6EE02D" Subject: Re: No restore of BLOB data (permissions?) Date: Tue, 28 Aug 2007 15:39:56 +0530 Importance: normal Message-ID: <8BE2E1772BEE8D40B0FB9E59DF2A645E0792D3E9@hcsmsg002.corp.satyam.ad> In-Reply-To: <509760.64585.qm@web34415.mail.mud.yahoo.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] No restore of BLOB data (permissions?) Thread-Index: AcfpWvbQ9EhX4qedQDG4hNi95qWS/QAADivw From: "Jayakumar_Mukundaraju" To: "Jordi Mulet" , X-OriginalArrivalTime: 28 Aug 2007 10:12:50.0457 (UTC) FILETIME=[FD50B890:01C7E95B] X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on hyd.satyam.com X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/344 X-Sequence-Number: 26675 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7E95B.FD6EE02D Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, =20 Try this command=20 =20 Pg_restore.exe -i -h localhost -p 5432 -U (username) -d (database_name) -V " Path of your Backup files" =20 Jayakumar M =20 ________________________________ From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jordi Mulet Sent: Tuesday, August 28, 2007 3:32 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] No restore of BLOB data (permissions?) =20 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 =20 pg_restore: restoring BLOBS pg_restore: [archiver] could not create large object 16591 pg_restore: *** aborted because of error =20 pg_dump.exe -h localhost -p 5432 -U postgres -v -o -F c -b database1 -f "database1.backup" =20 database1.backup is created (aprox. 25 MB) =20 error code 0 =20 I tried pg_restore -l in order to list contents of backup file and it seems some problem is detected on database1.backup: =20 1690; 0 0 BLOBS - BLOBS=20 1691; 0 0 BLOB COMMENTS - BLOB COMMENTS=20 =20 ________________________________ Looking for a deal? Find great prices on flights and hotels with Yahoo! FareChase. DISCLAIMER: This email (including any attachments) is intended for the sole use of = the intended recipient/s and may contain material that is CONFIDENTIAL = AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or = copying or distribution or forwarding of any or all of the contents in = this message is STRICTLY PROHIBITED. If you are not the intended = recipient, please contact the sender by email and delete all copies; = your cooperation in this regard is appreciated. ------_=_NextPart_001_01C7E95B.FD6EE02D Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

Try this command =

 

Pg_restore.exe –i –h = localhost  -p 5432 –U (username)  -d (database_name) –V “ = Path of your Backup files”

 

Jayakumar = M

 


From: = pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jordi Mulet
Sent: Tuesday, August 28, = 2007 3:32 PM
To: = pgsql-admin@postgresql.org
Subject: [ADMIN] No = restore of BLOB data (permissions?)

 

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

 


Looking for a deal? Find great prices on flights and hotels with Yahoo! = FareChase.

DISCLAIMER:
This email (including any attachments) is = intended for the sole use of the intended recipient/s and may contain = material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any = review or reliance by others or copying or distribution or forwarding of = any or all of the contents in this message is STRICTLY PROHIBITED. If = you are not the intended recipient, please contact the sender by email = and delete all copies; your cooperation in this regard is = appreciated.. ------_=_NextPart_001_01C7E95B.FD6EE02D-- From tgl@sss.pgh.pa.us Tue Aug 28 13:36:06 2007 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 From jmuletalbiach@yahoo.com Wed Aug 29 06:49:08 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4E4469F9F39 for ; Wed, 29 Aug 2007 03:49:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 51964-04 for ; Wed, 29 Aug 2007 03:49:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web34402.mail.mud.yahoo.com (web34402.mail.mud.yahoo.com [66.163.178.151]) by postgresql.org (Postfix) with SMTP id 4D72D9FA0B6 for ; Wed, 29 Aug 2007 03:49:04 -0300 (ADT) Received: (qmail 55769 invoked by uid 60001); 29 Aug 2007 06:49:03 -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:Content-Transfer-Encoding:Message-ID; b=nmhTAfjqqt+zc1+00a7zkFaI8a40DPUuyFYDtiOYzR5NRrpCnJYjpZJt7fW/Mv43bxHedxELi5occvfM8qAPPvDkGdzqvx1qOZkWL6EdEFFW99zzBmKg1aHSxPVzFjKAr6ugl8pz2y4WfQ1+ugfFJEOSDVT45l3dbajrfDDh9nE=; X-YMail-OSG: 5vcLv3IVM1kP3h2J1HOB.Nu8PHH.Wu4Ec_9iMLM67NwqfYmutkZD05FkKm8nD.DFGA-- Received: from [209.191.106.123] by web34402.mail.mud.yahoo.com via HTTP; Tue, 28 Aug 2007 23:49:02 PDT X-Mailer: YahooMailRC/651.48 YahooMailWebService/0.7.119 Date: Tue, 28 Aug 2007 23:49:02 -0700 (PDT) From: Jordi Mulet Subject: Re: No restore of BLOB data (permissions?) To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Message-ID: <944163.55004.qm@web34402.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/382 X-Sequence-Number: 26713 Version 8.2. =0Apg_restore 8.2.4 =0Apg_dump 8.2.4 =0A=0AInfo on log file: = =0A2007-08-29 08:46:52 ERROR: duplicate key violates unique constraint "pg_= largeobject_loid_pn_index" =0A=0ARegards, =0AJordi =0A=0A=0APlease fix your= mailer to not mangle text like that ... =0A=0AAnyway. I'm wondering about = version skew. What PG version is this, and =0Ain particular are the pg_rest= ore and server the same version? What =0Ashows up in the postmaster log whe= n this happens? =0A=0Aregards, tom lane =0A=0A---------------------------(e= nd of broadcast)--------------------------- =0ATIP 1: if posting/reading th= rough Usenet, please send an appropriate =0Asubscribe-nomail command to maj= ordomo@postgresql.org so that your =0Amessage can get through to the mailin= g list cleanly=0A=0A=0A =0A__________________________________________= __________________________________________Ready for the edge of your seat? = =0ACheck out tonight's top picks on Yahoo! TV. =0Ahttp://tv.yahoo.com/ From tgl@sss.pgh.pa.us Wed Aug 29 14:49:31 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AD5E39FA3F3 for ; Wed, 29 Aug 2007 11:49:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 04055-05-3 for ; Wed, 29 Aug 2007 11:49:21 -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 E09299FA3B3 for ; Wed, 29 Aug 2007 11:49:27 -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 l7TEnQ6k000413; Wed, 29 Aug 2007 10:49:26 -0400 (EDT) To: Jordi Mulet cc: pgsql-admin@postgresql.org Subject: Re: No restore of BLOB data (permissions?) In-reply-to: <944163.55004.qm@web34402.mail.mud.yahoo.com> References: <944163.55004.qm@web34402.mail.mud.yahoo.com> Comments: In-reply-to Jordi Mulet message dated "Tue, 28 Aug 2007 23:49:02 -0700" Date: Wed, 29 Aug 2007 10:49:26 -0400 Message-ID: <412.1188398966@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/391 X-Sequence-Number: 26722 Jordi Mulet writes: > Info on log file: > 2007-08-29 08:46:52 ERROR: duplicate key violates unique constraint "pg_lar= > geobject_loid_pn_index" So the problem is you've already *got* that blob, or at least one with the same OID, in the target database. Try restoring into an empty database. regards, tom lane