questions <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to