| 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: | Whole Thread | Raw Message | 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
| 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 |