From: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
---|---|
To: | Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Issue with OS X |
Date: | 2005-06-01 08:47:16 |
Message-ID: | BEC334A4.46D3D%awitney@sgul.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You will need to modify your shared memory settings or change your
shared_buffers parameter in the postgresql.conf file. (Most likely need to
increase SHMMAX as the default for OSX is quite low as I recall)
Take a look here:
http://www.postgresql.org/docs/8.0/static/kernel-resources.html
There is a section on MacOSX about half way down the page
HTH
Adam
> Hi,
> I am trying to install postgresql 8 on a G5 OS X machine and cannot get
> past this error i have tried changing the shared buffer with no luck.
>
> Error message:
> /usr/local/pgsql/data postgres$ FATAL: could not create shared memory
> segment: Invalid argument
>
> DETAIL: Failed system call was shmget(key=5432001, size=10338304, 03600).
>
> HINT: This error usually means that PostgreSQL's request for a shared
> memory segment exceeded your kernel's SHMMAX parameter. You can either
> reduce the request size or reconfigure the kernel with larger SHMMAX.
> To reduce the request size (currently 10338304 bytes), reduce
> PostgreSQL's shared_buffers parameter (currently 1000) and/or its
> max_connections parameter (currently 100).
>
> If the request size is already small, it's possible that it is
> less than your kernel's SHMMIN parameter, in which case raising the
> request size or reconfiguring SHMMIN is called for.
>
> The PostgreSQL documentation contains more information about
> shared memory configuration.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2005-06-01 09:33:48 | Re: Missing numbers |
Previous Message | Roman Neuhauser | 2005-06-01 08:37:48 | Re: Shared memory and FreeBSD's jail() |