Forum OpenACS Q&A: Memory exhausted in AllocSetAlloc()

My data model loading is ending with this error:

psql:ecommerce.sql:580: FATAL 1: Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
psql:ecommerce.sql:580: connection to server was lost

Do I need more memory? I think I only have 16megs...or is this a diskspace problem? How big is an empty data model?

Also...for RPM installers of PostgreSQL 7.0, it'd be helpful to put in the notes that initdb needs to be run. (I know...I should have looked at L. Owens site more clossely...)

Thanks.

Collapse
Posted by Don Baccus on
You need more RAM or a larger swap partition, it sounds like.  I checked the PG sources to be sure, and the error is generated when malloc() fails.  So, yep, it's really really out of memory.