Re: clarifications needed on postgres/perl

Srishti Software Pvt. Ltd. wrote:

> Hi!,
> we are using postgresql(6.3.2-10) on red-hat linux 5.2.
>  we use perl-5 to access postgres.
>  the problem we have is :
>  we have a table having 13 fields, now when updating one of the fields
>  from the perl program, for more than 800 records, the following error
> is
>  reported :
>      "FATAL 1: palloc failed: memory exhausted."
>  how ever when doing the same directly in psql monitor, there is no
>  error. also when the number of records to be updated are below 800
> there
>  is no error.
>
>  We also changed the buffer size to 256, still we get an error like:
>
>         IpcMemoryCreate: memKey=155356396 , size=760632 ,
>         permission=384IpcMemoryCreate: shmget(..., create, ...)
>         failed: Invalid argument
>
>         i know I have to build IPC support into the Linux kernel. i
>         will have to rebuild the kernel and switch on this option.
>
>  can u please tell me how to do it.?
>
>  kindly suggest some remidies,
>  we will be very thankful.
>
>  looking forward to ur valuable suggestions very soon,
>  with best regards,
>  Team srishti.