Received: from aua2.aua.auc.dk (aua2.aua.auc.dk [130.225.54.5]) by hub.org (8.10.1/8.11.0) with ESMTP id e9OKNYN41835 for ; Tue, 24 Oct 2000 16:23:34 -0400 (EDT) (envelope-from poulc@cs.auc.dk) Received: from obel.auc.dk (cw.obel.auc.dk [192.168.64.3]) by aua.auc.dk (PMDF V5.2-32 #30369) with SMTP id <01JVQCDCF0ZY8Y6NG7@aua.auc.dk> for pgsql-sql@postgresql.org; Tue, 24 Oct 2000 22:23:31 MET-DST Received: (qmail 16202 invoked from network); Tue, 24 Oct 2000 20:19:57 +0000 Received: from plc.obel.auc.dk (HELO cs.auc.dk) (192.168.64.31) by cw.obel.auc.dk with SMTP; Tue, 24 Oct 2000 20:19:57 +0000 Date: Tue, 24 Oct 2000 22:22:20 +0100 From: "Poul L. Christiansen" Subject: Re: Error in Extrack Database To: Tubagus Nizomi Cc: pgsql-sql@postgresql.org Message-id: <39F5FD8C.67ACEB2B@cs.auc.dk> MIME-version: 1.0 X-Mailer: Mozilla 4.71 [en] (WinNT; I) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en,pdf References: <00102502170708.00721@nizomi.dnet.net.id> X-Archive-Number: 200010/210 X-Sequence-Number: 1872 My guess is that you don't have enough RAM. Maybe it can work if you first unzip the file, then log into database internal and use the command "\i data.dump" to load the data. If that doesn't work, try splitting up the file and load the files separatly. Poul L. Christiansen Tubagus Nizomi wrote: > > i have file Dump > 500 MB > when i execute " gunzip -c data.dump.gz | psql internal " > > some error message emerged as follows : > FATAL 1: copy: line 2516273, Memory exhausted in AllocSetAlloc() > > what might be happen with the process ?? > how to solve the problem ?? > > i use sparc sun solaris 2.6, postgres 6.5.3, memory 256 MB > > thanks > Nizomi