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 027CCD1D065 for ; Wed, 7 Apr 2004 06:28:19 -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 99628-06 for ; Wed, 7 Apr 2004 06:28:19 -0300 (ADT) Received: from mta05-svc.ntlworld.com (mta05-svc.ntlworld.com [62.253.162.45]) by svr1.postgresql.org (Postfix) with ESMTP id 51A92D1C9B5 for ; Wed, 7 Apr 2004 06:28:16 -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 <20040407092709.QRZJ4091.mta05-svc.ntlworld.com@evesham> for ; Wed, 7 Apr 2004 10:27:09 +0100 From: "Marion McKelvie" To: Subject: Re: restoring large objects Date: Wed, 7 Apr 2004 10:28:34 +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 In-Reply-To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/104 X-Sequence-Number: 13077 Good news - the restore worked fine with the new column type and the application worked fine once I'd added a duplicate column of type text. So at least I have a workable recovery procedure! Many thanks for your help. Marion -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Marion McKelvie Sent: 07 April 2004 08:44 To: pgsql-admin@postgresql.org Subject: Re: [ADMIN] restoring large objects Good idea but I'm not sure if the application will then handle the changed column type correctly. I'll give it a go and let you know... -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Tom Lane Sent: 07 April 2004 07:08 To: Marion McKelvie Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] restoring large objects "Marion McKelvie" writes: > Many thanks - you're right, the references are stored (by the application > using the database) in a column of type text. Yuck :-(. A possible solution is to dump the schema and data separately (schema in a plain text dump, data in an -Fc or -Ft dump since plain text doesn't support dumping LOs). Then manually edit the schema file to change the column data type to "oid". Then load. I honestly am not sure that this will work cleanly, but it's worth trying --- and if it doesn't work, please let me know where it goes wrong. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings