From: | Timothy Perrigo <tperrigo(at)wernervas(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: OSX 10.3.7 broke Postgresql 8.0.0b5? |
Date: | 2004-12-18 00:43:08 |
Message-ID: | C95D8E70-508D-11D9-B422-000A95C4F0A2@wernervas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm getting the same error now too, although postgres was running
without problem this morning (I updated the OS yesterday). OS X 10.3.7
Server, PostgreSQL 8.0RC1. Basically, I did a pg_dump, stopped the
server and then tried to start it again.
Any ideas?
On Dec 17, 2004, at 2:41 PM, Jerry LeVan wrote:
> I *think* the 10.3.7 upgrade broke my postgresql implementation...
>
> I am getting this error at startup.
>
> FATAL: could not create shared memory segment: Cannot allocate memory
> DETAIL: Failed system call was shmget(key=5432001, size=10403840,
> 03600).
> HINT: This error usually means that PostgreSQL's request for a shared
> memory segment exceeded available memory or swap space. To reduce the
> request size (currently 10403840 bytes), reduce PostgreSQL's
> shared_buffers parameter (currently 1000) and/or its max_connections
> parameter (currently 100).
> The PostgreSQL documentation contains more information about
> shared memory configuration.
>
> The first time I noticed the problem I found that the shmmax was set
> low
> at a bit more than 4MB ( perhaps the upgrade replaced /etc/rc ).
>
> I increased the shmmax to about 64MB and still get the same error.
>
> Here are the current kernel settings
>
> kern.sysv.shmmax: 67108864
> kern.sysv.shmmin: 1
> kern.sysv.shmmni: 32
> kern.sysv.shmseg: 8
> kern.sysv.shmall: 1024
> kern.sysv.semmni: 87381
> kern.sysv.semmns: 87381
> kern.sysv.semmnu: 87381
> kern.sysv.semmsl: 87381
> kern.sysv.semume: 10
>
> Do I need to increase anything else?
>
> I am on the digest, if someone knows the answer please CC to me also...
>
> Jerry
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2004-12-18 02:46:34 | Re: Scheduler in Postgres |
Previous Message | Jerry LeVan | 2004-12-17 23:29:10 | Contacting Tom Lane :) |