"Francisco Reyes" <lists@xxxxxxxxxxxxxxxx> writes: > There is no "ulimit -a" in cshell which is what I use. > I guessed this may be a bash setting .. so tried that.. > The output of ulimit -a is: The csh equivalent is just "limit". > core file size (blocks, -c) unlimited > data seg size (kbytes, -d) 524288 > > Don't see any limit at 128MB, the size at which the program crashed. You might try starting Postgres with ulimit -d unliited or limit datasize unlimit You're right that your limit is above 128M but the error just means it tried to allocated 128M and failed, it may already have allocated 400M and been trying to go over the 524M mark. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
