X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3C7E3476719 for ; Mon, 31 Mar 2003 10:37:59 -0500 (EST) Received: from paiol.terra.com.br (paiol.terra.com.br [200.176.3.18]) by postgresql.org (Postfix) with ESMTP id B92E14766A1 for ; Mon, 31 Mar 2003 09:17:28 -0500 (EST) Received: from jurua.terra.com.br (jurua.terra.com.br [200.176.3.42]) by paiol.terra.com.br (Postfix) with ESMTP id CADC388259 for ; Mon, 31 Mar 2003 11:17:31 -0300 (BRT) Received: from insyde (200-171-250-250.customer.telesp.net.br [200.171.250.250]) (authenticated user insyde09) by jurua.terra.com.br (Postfix) with ESMTP id 53CEEB0060 for ; Mon, 31 Mar 2003 11:17:31 -0300 (BRT) Message-ID: <014401c2f790$7c244be0$fafaabc8@insyde> From: "lists" To: References: <003201c2f526$8e88fd60$8efaabc8@insyde> <1049118197.13798.1712.camel@camel> Subject: Re: pg_restore problem Date: Mon, 31 Mar 2003 11:19:02 -0300 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 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-10.8 required=5.0 tests=BAYES_30,QUOTED_EMAIL_TEXT,RCVD_IN_OSIRUSOFT_COM,REFERENCES 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/492 X-Sequence-Number: 8132 > 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). Yes, I'm sure it is an empty database. I didn't mention in the e-mail, but the complete script I did is: $pg_dump -s DB1 > DB1.sql $pg_dump -a -b -Fc -f DB1.dump -o -v DB1 $dropdb DB2 $createdb DB2 $psql DB2 As for the -Ft vs. -Fc size question, the tar format is not a compressed > format, while the "c"ustom format is. Thanks. Ricardo.