Re: initdb memory segment creation error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: questions <questions(dot)612(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: initdb memory segment creation error
Date: 2008-09-11 23:47:27
Message-ID: 16449.1221176847@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

questions <questions(dot)612(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2008-09-12 01:09:51 Re: external query VS user function
Previous Message Stephen Frost 2008-09-11 23:38:06 Re: Windows ODBC Driver