Re: initdb memory segment creation error - Mailing list pgsql-general

From Tom Lane
Subject Re: initdb memory segment creation error
Date
Msg-id 16449.1221176847@sss.pgh.pa.us
Whole thread Raw
In response to Re: initdb memory segment creation error  (questions <questions.612@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Windows ODBC Driver
Next
From: "Merlin Moncure"
Date:
Subject: Re: external query VS user function