Skip site navigation (1) Skip section navigation (2)

Re: Error in Extrack Database

From: "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
To: Tubagus Nizomi <nizomi(at)dnet(dot)net(dot)id>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error in Extrack Database
Date: 2000-10-24 21:22:20
Message-ID: 39F5FD8C.67ACEB2B@cs.auc.dk (view raw or flat)
Thread:
Lists: pgsql-sql
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

In response to

pgsql-sql by date

Next:From: Josh BerkusDate: 2000-10-24 22:05:25
Subject: Re: help on createing table
Previous:From: Albert REINERDate: 2000-10-24 21:15:10
Subject: Re: help on creating table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group