X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D36A9475CBC for ; Wed, 2 Apr 2003 15:21:24 -0500 (EST) Received: from ivoti.terra.com.br (ivoti.terra.com.br [200.176.3.20]) by postgresql.org (Postfix) with ESMTP id B738D474E44 for ; Wed, 2 Apr 2003 15:21:23 -0500 (EST) Received: from canela.terra.com.br (canela.terra.com.br [200.176.3.79]) by ivoti.terra.com.br (Postfix) with ESMTP id C5CFD408EEC for ; Wed, 2 Apr 2003 17:21:23 -0300 (BRT) Received: from insyde (200-171-250-50.customer.telesp.net.br [200.171.250.50]) (authenticated user insyde09) by canela.terra.com.br (Postfix) with ESMTP id 64881114034 for ; Wed, 2 Apr 2003 17:21:23 -0300 (BRT) Message-ID: <012f01c2f955$a2c74560$32faabc8@insyde> From: "lists" To: Subject: restore time Date: Wed, 2 Apr 2003 17:22:50 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_012C_01C2F93C.7CE2FD80" 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=-0.7 required=5.0 tests=BAYES_30,HTML_40_50,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: 200304/25 X-Sequence-Number: 8180 This is a multi-part message in MIME format. ------=_NextPart_000_012C_01C2F93C.7CE2FD80 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hi, I'm trying to restore a database, btu I couldn't so far. It's taking more than 14 hours to complete, and we make=20 a valuation of more than 22 hours to complete restore a 1,5 Gb database, from a 60 mb dump. This only happen when I use the binary mode (-Fc) with plain text it takes at most 3 hours. I need this mode because of the lo types. Is anyone having this kind of problem? How long your dump/restore=20 takes to complete? What's the size of the DB? Is there any workaround? TIA, Ricardo. ------=_NextPart_000_012C_01C2F93C.7CE2FD80 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
Hi, I'm trying to restore a database, btu = I=20 couldn't so far.
It's taking more than 14 hours to complete= ,=20 and we make
a valuation of more than 22 hours to compl= ete=20 restore a 1,5 Gb
database, from a 60 mb dump.
 
This only happen when I use the binary mod= e (-Fc)=20 with plain text
it takes at most 3 hours. I need this mode= because=20 of the lo types.
 
Is anyone having this kind of problem? How= =20 long your dump/restore
takes to complete? What's the size of the= =20 DB?
 
Is there any workaround?
 
TIA,
Ricardo.
------=_NextPart_000_012C_01C2F93C.7CE2FD80--