X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 25C67D873E for ; Wed, 31 Aug 2005 00:41:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72677-05 for ; Wed, 31 Aug 2005 03:41:15 +0000 (GMT) Received: from chiron.lunarpages.com (chiron.lunarpages.com [64.235.234.14]) by svr1.postgresql.org (Postfix) with ESMTP id 274D9D8734 for ; Wed, 31 Aug 2005 00:41:14 -0300 (ADT) Received: from c-24-6-85-89.hsd1.ca.comcast.net ([24.6.85.89] helo=[192.168.1.36]) by chiron.lunarpages.com with esmtpa (Exim 4.50) id 1EAJTI-0001jv-W5 for pgsql-admin@postgresql.org; Tue, 30 Aug 2005 20:41:09 -0700 Mime-Version: 1.0 (Apple Message framework v734) Content-Transfer-Encoding: 7bit Message-Id: <81ADABD9-9796-4AAE-AC83-AD033A7F99ED@mitchellfamily.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-admin@postgresql.org From: Ben Mitchell Subject: Backup / Restore help Date: Tue, 30 Aug 2005 20:41:07 -0700 X-Mailer: Apple Mail (2.734) X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - chiron.lunarpages.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - mitchellfamily.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/406 X-Sequence-Number: 18725 Hi, I've got a problem, I'm hoping someone can help me with. It appears that my hosting provider has "restored" my database as part of a maintenance project. The problem is that the backup didn't include my large objects. I've got an older backup that has all the large objects, but I don't know how to partially restore just the large objects. Neither do I want to overwrite the other data, leaving the database at an earlier snapshot than is absolutely necessary. Is there a way to restore just the large objects from a backup tar created by pg_dump, leaving the rest of the database intact? Thanks, -Ben Mitchell