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 07295D1B349 for ; Thu, 27 May 2004 18:17:08 -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 29102-08 for ; Thu, 27 May 2004 18:16:48 -0300 (ADT) Received: from hotmail.com (bay9-f49.bay9.hotmail.com [64.4.47.49]) by svr1.postgresql.org (Postfix) with ESMTP id A4869D1B1BD for ; Thu, 27 May 2004 18:16:44 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 27 May 2004 14:16:46 -0700 Received: from 65.242.105.130 by by9fd.bay9.hotmail.msn.com with HTTP; Thu, 27 May 2004 21:16:46 GMT X-Originating-IP: [65.242.105.130] X-Originating-Email: [dedeb17@hotmail.com] X-Sender: dedeb17@hotmail.com From: "Sally Sally" To: pgsql-admin@postgresql.org Subject: pg_restore quick question Date: Thu, 27 May 2004 21:16:46 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 27 May 2004 21:16:46.0482 (UTC) FILETIME=[EAB0BF20:01C4442F] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200405/299 X-Sequence-Number: 13615 I want to dump a database containing about five tables, each containing about 25 million records. I wanted to run pg_restore per table all at the same time. Would this have any undesirable consequences. I tried it on a smaller database and it seems to work fine. Let me know your thoughts ASAP Thanks Sally _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/