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/