Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EC7D79FB490 for ; Thu, 22 Feb 2007 11:43:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 14166-06-2 for ; Thu, 22 Feb 2007 11:43:19 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web50304.mail.yahoo.com (web50304.mail.yahoo.com [206.190.38.58]) by postgresql.org (Postfix) with SMTP id 870E69FBB18 for ; Thu, 22 Feb 2007 11:43:19 -0400 (AST) Received: (qmail 73736 invoked by uid 60001); 22 Feb 2007 15:43:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=f5+6lQ2DclxLBQ2Vy46TCc1qICVssmGjJyMVXvDRVapQJ/sIuUnx8KFLY3QJWxVsQwfWYvm4s0VGKkwQkeBBbUBzVPQoYiNickn0eHtgexxPJ9LRXZz+J78N3zxtyets7iyE/6VUJtyCJn92Ccb0gOLb7NnyjK9ifjBaK9CJz+4=; X-YMail-OSG: WdqjuVcVM1n9TYIhefTdFBG64_nKaTIp274v0N6k4yVSJQQTHGmw1O_ZI_iW8Carhd4LhTxEdHpgOJoNXOHLUtBD09gmc3hZoBX9sNLRA1I2x46wE1KK4J8SNsd37QGiQloI226v4C.h7g-- Received: from [58.63.153.142] by web50304.mail.yahoo.com via HTTP; Thu, 22 Feb 2007 07:43:13 PST X-Mailer: YahooMailRC/368.8 YahooMailWebService/0.6.132.8 Date: Thu, 22 Feb 2007 07:43:13 -0800 (PST) From: ogjunk-pgjedan@yahoo.com Subject: Fastest DB restore options To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Message-ID: <821429.69798.qm@web50304.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.317 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, NO_REAL_NAME X-Spam-Level: **** X-Archive-Number: 200702/288 X-Sequence-Number: 24753 Hello,=0A=0AI have a fairly large DB to dump and restore as fast as possibl= e. I'm moving from 8.0.3 to 8.2.3! :)=0A=0AI normally dump with these opti= ons:=0A=0A -d MyDB --clean --inserts --column-inserts --format=3DP=0A=0ABu= t the last time I tried that, the restore took foreeeeeeeeeeeeeever. So I'= m looking for the fastest way to import data from the old DB to the new one= . Judging from pg_dump man page the following should be the fastest dump &= restore:=0A=0A -d MyDB --format=3Dc --ignore-version=0A =0AIs there anyth= ing else I can do to make the restore as fast as possible?=0A=0AThanks,=0AO= tis=0A=0A. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .=0ASimp= y -- http://www.simpy.com/ - Tag - Search - Share=0A=0A