questions <questions.612@gmail.com> writes:
> I have few other applications running on my machine but they all don't use
> more than 60MB. I checked and SHMALL is in pages. I also reduced
> shared_buffers and max_connections but that didn't help. Also I did ipcs
> after I got the error and following is what I got -
> [ lots of pre-existing segments ]
Well, there's your problem. You need to clean those up. See "ipcrm",
or it might be easier just to reboot the machine.
> Postgres did create, attach, detach shared segments but did'nt delete them.
So it would seem. What Postgres version is this, on what platform
*exactly* (a kernel version number would be good)?
regards, tom lane