X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 69A4C3A4B2E for ; Fri, 29 Oct 2004 13:14:20 +0100 (BST) 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 93316-01 for ; Fri, 29 Oct 2004 12:14:14 +0000 (GMT) Received: from mail2.wallstreet-develop.de (mail2.wallstreet-develop.de [194.126.132.129]) by svr1.postgresql.org (Postfix) with SMTP id 18C163A4B5F for ; Fri, 29 Oct 2004 13:14:16 +0100 (BST) Received: (qmail 5597 invoked from network); 29 Oct 2004 12:06:18 -0000 Received: from unknown (HELO ?192.168.1.61?) (jr@83.236.156.211) by mail2.wallstreet-develop.de with SMTP; 29 Oct 2004 12:06:18 -0000 Message-ID: <41823417.3010200@yahoo.de> Date: Fri, 29 Oct 2004 14:14:15 +0200 From: Janko Richter User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-1?Q?D=FCster_Horst?= , pgsql-admin@postgresql.org Subject: Re: pg_restore error References: <5B025B1F39D6D4119F5700508BEEEC66F94BF5@SRSOFAIOI4546> In-Reply-To: <5B025B1F39D6D4119F5700508BEEEC66F94BF5@SRSOFAIOI4546> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/373 X-Sequence-Number: 15366 Hi, Try "pg_restore -l" to generate a TOC. You may rearrange the TOC file. Then use "pg_restore -L". Hope it helps, Janko Richter Düster Horst wrote: > Vishal > > Thank you for your answer. My problem is, I have to restore BLOBS. The > documentation says, it's only possible to restore blobs with pg_restore in > one part. The way you suppose does not work with BLOBS because the > restauration of single objects will not restore BOLBS. > > Horst Düster > > -----Ursprüngliche Nachricht----- > Von: Vishal Kashyap @ [Sai Hertz And Control Systems] > [mailto:vishalonlist@gmail.com] > Gesendet am: Freitag, 29. Oktober 2004 11:33 > An: Düster Horst > Cc: pgsql-admin@postgresql.org > Betreff: Re: [ADMIN] pg_restore error > > Hi > > >>I thought, that pg_restore will organize the restore-prozess in an optimal >>order. This seems not work correct!!?? I would be grateful to hear any >>hints. > > > > pg_restore does not priortize till now idealy it must be like > restoring the functions >> tables >> views >> seqences so on... > > This is in the todo > > http://developer.postgresql.org/todo.php > > but for mean while you would have to use pg_restore to restore the > tables one by one and then let other thing go on. > > moreover if your database is not to large its best to make a text file > of the dump and run it through psql > >