X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 6FA7A47580B for ; Fri, 28 Mar 2003 07:34:31 -0500 (EST) Received: from paiol.terra.com.br (paiol.terra.com.br [200.176.3.18]) by postgresql.org (Postfix) with ESMTP id 56DFB474E44 for ; Fri, 28 Mar 2003 07:34:22 -0500 (EST) Received: from sapucaia.terra.com.br (sapucaia.terra.com.br [200.176.3.41]) by paiol.terra.com.br (Postfix) with ESMTP id 20B7B88264 for ; Fri, 28 Mar 2003 09:34:24 -0300 (BRT) Received: from insyde (200-171-250-142.customer.telesp.net.br [200.171.250.142]) (authenticated user insyde09) by sapucaia.terra.com.br (Postfix) with ESMTP id 8CE99304066 for ; Fri, 28 Mar 2003 09:34:23 -0300 (BRT) Message-ID: <003201c2f526$8e88fd60$8efaabc8@insyde> From: "lists" To: Subject: pg_restore problem Date: Fri, 28 Mar 2003 09:35:44 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002F_01C2F50D.68047DE0" 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=-1.0 required=5.0 tests=BAYES_30,HTML_50_60,RCVD_IN_OSIRUSOFT_COM version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/479 X-Sequence-Number: 8119 This is a multi-part message in MIME format. ------=_NextPart_000_002F_01C2F50D.68047DE0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable 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.=20 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=20 and stopped the process. Tried with both Ft and Fc.=20 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=20 Free space ~5GB. TIA, Ricardo. ------=_NextPart_000_002F_01C2F50D.68047DE0 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
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. <= /DIV>
 
The dump takes abou 1 hour, but the restor= e takes=20 forever!
 
Last time I ran it, it takes more than 10 = hours,=20 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=20 about the
same size of the original DB(1.5GB) and wi= th Fc it=20 has about 50MB?
 
My system is:
P3 1Ghz, 1GB ram, Win2k, Postgres 7.2.2=20
Free space ~5GB.
 
TIA,
 
Ricardo.
------=_NextPart_000_002F_01C2F50D.68047DE0--