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 7A0E6D1DD86 for ; Tue, 17 Feb 2004 23:59:54 +0000 (GMT) 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 99903-07 for ; Tue, 17 Feb 2004 19:59:52 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 5004DD1D2E3 for ; Tue, 17 Feb 2004 19:59:49 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1HNxq1K019064; Tue, 17 Feb 2004 18:59:52 -0500 (EST) To: Warren Little Cc: pgsql-admin@postgresql.org Subject: Re: large objects missing In-reply-to: <1077037848.5869.5.camel@localhost.localdomain> References: <1077037848.5869.5.camel@localhost.localdomain> Comments: In-reply-to Warren Little message dated "Tue, 17 Feb 2004 10:10:48 -0700" Date: Tue, 17 Feb 2004 18:59:51 -0500 Message-ID: <19063.1077062391@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/264 X-Sequence-Number: 12438 Warren Little writes: > In an attempt to migrate from 7.3 to 7.4 doing a pg_dumpall I did not > get any of my large objects. Is there a special process which needs to > take place and is there a way to simple copy the large objects > seperately? pg_dumpall doesn't handle large objects, because it can only do textual output format and pg_dump doesn't have a way to dump large objects textually. What you have to do at the moment is use pg_dump individually on each DB that contains large objects, specifying either -Fc or -Ft (I'd recommend the former) plus -b to dump blobs. Then pg_restore each of these dumps. I think you can use pg_restore's list option to select just the blobs to be restored, but I'm not sure how well that really works when the destination DB has already been modified to some extent. You'd be well advised to experiment in a scratch copy of the database before you try it on your live DB. regards, tom lane