Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8E6A89FB2DC for ; Thu, 5 Apr 2007 18:42:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 86286-06 for ; Thu, 5 Apr 2007 18:42:55 -0300 (ADT) X-Greylist: delayed 00:29:21.58098 by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 86E189FB362 for ; Thu, 5 Apr 2007 18:42:55 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mxca2.corp.netopia.com (mx-us-west.netopia.com [65.206.239.221]) by svr4.postgresql.org (Postfix) with ESMTP id 88FFB5AF074 for ; Thu, 5 Apr 2007 21:13:32 +0000 (GMT) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Restoring single database from an export dump of a cluster Date: Thu, 5 Apr 2007 14:13:45 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Restoring single database from an export dump of a cluster Thread-Index: Acd3x0u0entkLGC3R7azA/Nz9qNCcg== From: "Bhella, Paramjeet" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200704/89 X-Sequence-Number: 25153 Hi In our production environment we use pg_dumpall to backup all the databases of a cluster as there are 200+ databases in a cluster. Some times there is a situation where we have to restore a single database from a cluster. According to the postgres docs there is a pg_restore utiltity which can be used to restore individual tables, schemas, databases etc. But pg_restore requires the pg_dump to be in archive format. With pg_dump we can use option -Fc to make the dump in non-plain text format but I cannot use -Fc option with pg_dumpall. Is there a way to import a single database from an export dump of a cluster? Your help or guidance will be highly appreciated. Thanks Paramjeet Kaur Professional Services and Motorola Broadband Solutions Group