pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Error in Extrack Database
2+ messages / 2 participants
[nested] [flat]

* Error in Extrack Database
@ 2000-10-24 19:06 Tubagus Nizomi <nizomi@dnet.net.id>
  2000-10-24 21:22 ` Re: Error in Extrack Database Poul L. Christiansen <poulc@cs.auc.dk>
  0 siblings, 1 reply; 2+ messages in thread

From: Tubagus Nizomi @ 2000-10-24 19:06 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Error in Extrack Database
  2000-10-24 19:06 Error in Extrack Database Tubagus Nizomi <nizomi@dnet.net.id>
@ 2000-10-24 21:22 ` Poul L. Christiansen <poulc@cs.auc.dk>
  0 siblings, 0 replies; 2+ messages in thread

From: Poul L. Christiansen @ 2000-10-24 21:22 UTC (permalink / raw)
  To: Tubagus Nizomi <nizomi@dnet.net.id>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-10-24 21:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-24 19:06 Error in Extrack Database Tubagus Nizomi <nizomi@dnet.net.id>
2000-10-24 21:22 ` Poul L. Christiansen <poulc@cs.auc.dk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox