X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 46AE04764C3 for ; Mon, 31 Mar 2003 10:39:52 -0500 (EST) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id A6D1E47667E for ; Mon, 31 Mar 2003 08:43:16 -0500 (EST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.5/8.12.5) with ESMTP id h2VEJa6P000516; Mon, 31 Mar 2003 09:19:36 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h2VDhHp23113; Mon, 31 Mar 2003 08:43:17 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id F3HTLJQK; Mon, 31 Mar 2003 08:43:15 -0500 Subject: Re: pg_restore problem From: Robert Treat To: lists Cc: pgsql-admin@postgresql.org In-Reply-To: <003201c2f526$8e88fd60$8efaabc8@insyde> References: <003201c2f526$8e88fd60$8efaabc8@insyde> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 31 Mar 2003 08:43:16 -0500 Message-Id: <1049118197.13798.1712.camel@camel> Mime-Version: 1.0 X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/499 X-Sequence-Number: 8139 Are you sure your restoring to an empty database? If you try to restore your dump into the database you dumped it from (without first drop/create) it will take forever as you'll have all kinds of data collisions (imagine every insert into a table erroring out due to duplicate primary key). As for the -Ft vs. -Fc size question, the tar format is not a compressed format, while the "c"ustom format is. Robert Treat On Fri, 2003-03-28 at 07:35, lists wrote: > Hi, > > I've a dump I made with the command: > > pg_dump -a -b -Fc -f DB.dump -o -v DB > > then I try to restore with: > > pg_restore -a -d DB2 -Fc -o -v DB.dump > > This database is about 1.5Gb big. > > The dump takes abou 1 hour, but the restore takes forever! > > Last time I ran it, it takes more than 10 hours, when I gave up > and stopped the process. > > Tried with both Ft and Fc. > > Another doubt: Why a dump of this DB with Ft has about the > same size of the original DB(1.5GB) and with Fc it has about 50MB? > > My system is: > P3 1Ghz, 1GB ram, Win2k, Postgres 7.2.2 > Free space ~5GB. > > TIA, > > Ricardo.