X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D1069D1B498 for ; Tue, 6 Apr 2004 09:01:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 01801-01 for ; Tue, 6 Apr 2004 09:02:21 -0300 (ADT) Received: from mta05-svc.ntlworld.com (mta05-svc.ntlworld.com [62.253.162.45]) by svr1.postgresql.org (Postfix) with ESMTP id 5F430D1BA9F for ; Tue, 6 Apr 2004 09:01:33 -0300 (ADT) Received: from evesham ([80.1.245.211]) by mta05-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with SMTP id <20040406120111.IXXJ4091.mta05-svc.ntlworld.com@evesham> for ; Tue, 6 Apr 2004 13:01:11 +0100 From: "Marion McKelvie" To: Subject: restoring large objects Date: Tue, 6 Apr 2004 13:02:35 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=BAYES_44, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200404/88 X-Sequence-Number: 13061 Please can anyone confirm (or otherwise) the situation with restoring large objects? I am running with 7.1.2 (I know it's old, but I don't have a lot of choice given the application running on it), and have dumped the database with the -b option. However, the restoration process generates new ids for the large objects which means the link between the data table referencing them and the content of pg_largeobject is lost. I have seen a reference in the list archives to this being a bug, but can not find any reference to a workround or resolution. Does anyone know if there is one? I have a separate newer installation on 7.3.4. Is this still a problem on the newer versions? Many thanks for any assistance Marion