X-Original-To: pgsql-admin@postgresql.org Received: from itaqui.terra.com.br (itaqui.terra.com.br [200.176.3.19]) by postgresql.org (Postfix) with ESMTP id DC020474E4F for ; Tue, 18 Mar 2003 08:21:19 -0500 (EST) Received: from marova.terra.com.br (marova.terra.com.br [200.176.3.39]) by itaqui.terra.com.br (Postfix) with ESMTP id 840163BC63A for ; Tue, 18 Mar 2003 10:21:22 -0300 (BRT) Received: from insyde (200-171-250-65.customer.telesp.net.br [200.171.250.65]) (authenticated user insyde09) by marova.terra.com.br (Postfix) with ESMTP id 290B83DC09F for ; Tue, 18 Mar 2003 10:21:22 -0300 (BRT) Message-ID: <00bd01c2ed51$630374e0$41faabc8@insyde> From: "lists" To: Subject: Problems with pg_restore Date: Tue, 18 Mar 2003 10:22:11 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00BA_01C2ED38.3D26CE20" 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-Archive-Number: 200303/311 X-Sequence-Number: 7951 This is a multi-part message in MIME format. ------=_NextPart_000_00BA_01C2ED38.3D26CE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I've made a dump from PostgreSQL 7.2.2 under Win2k with the command: $pg_dump -o -C -b -Ft -i -O -v DataBaseName > DBN.dump Then I've tried to restore it to another instalation, in another server (Re= dHat 7.3, PostgreSQL 7.2.4) $pg_restore -Ft DBN.dump -d DataBaseName But then I get this message: pg_restore: [archiver] out of memory Is there any workaround? TIA, Ricardo ------=_NextPart_000_00BA_01C2ED38.3D26CE20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I've made a dump from PostgreSQL 7.2.2&nbs= p;under=20 Win2k with the command:
 
    $pg_dump -o -C -b -Ft -= i -O -v=20 DataBaseName > DBN.dump
 
Then I've tried to restore it to another= =20 instalation, in another server (RedHat 7.3, PostgreSQL 7.2.4)
 
    $pg_restore -Ft DBN.dum= p -d=20 DataBaseName
 
But then I get this message:
 
    pg_restore: [archiver] = out of=20 memory
 
Is there any workaround?
 
TIA,
Ricardo
------=_NextPart_000_00BA_01C2ED38.3D26CE20--