X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B886FD1D3FB for ; Mon, 1 Dec 2003 10:14:33 +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 71598-08 for ; Mon, 1 Dec 2003 06:14:04 -0400 (AST) Received: from mail.networkprograms.com (unknown [203.190.139.254]) by svr1.postgresql.org (Postfix) with ESMTP id 254D7D1D40B for ; Mon, 1 Dec 2003 06:14:00 -0400 (AST) Received: from KAMALR ([192.9.203.78]) by mail.networkprograms.com (8.12.9/8.12.9) with SMTP id hB1AIDfb018881; Mon, 1 Dec 2003 15:48:19 +0530 Message-ID: <01d601c3b7f4$61897f10$4ecb09c0@KAMALR> Reply-To: "Kamalraj Singh Madhan" From: "Kamalraj Singh Madhan" To: "Jason Tishler" Cc: References: <4c0ccf4c27ff.4c27ff4c0ccf@jhmimail.jhmi.edu> <3FC54A82.2040605@familyhealth.com.au> <20031127032831.GA4836@gp.word-to-the-wise.com> <3FC58097.8090803@familyhealth.com.au> <20031127051230.GA6212@gp.word-to-the-wise.com> <20031128050417.GA14227@gp.word-to-the-wise.com> <3FC6DAB8.4080106@familyhealth.com.au> <20031128203700.GA19831@gp.word-to-the-wise.com> <3FC9BC76.2030308@familyhealth.com.au> Subject: Dump restoration via archive files Date: Mon, 1 Dec 2003 15:47:47 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Scanned-By: MIMEDefang 2.35 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=REFERENCES X-Spam-Level: X-Archive-Number: 200312/1 X-Sequence-Number: 4861 Hi, I'am taking dump of a huge database and do not want the restoration of that dump to take a lot of time as is the case when you take the dump in text files. I want to take the dump as an archive file and get it restored in very less time. I'am not able to figure out what is the command for taking dump of a database in a archive file. Kindly help it's urgent. thanks and regards Kamalraj Singh