I set the System V IPC parameters to the suggested defaults and it worked.
set shmsys:shminfo_shmmax=0x2000000
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmseg=256
set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=512
set semsys:seminfo_semmns=512
set semsys:seminfo_semmsl=32
Thanks Tom .
-Sathish
At 09:39 AM 10/22/2003 -0400, Tom Lane wrote:
>Sathish Somanathan <sathish@cisco.com> writes:
> > IpcSemaphoreCreate: semget(key=5432001, num=17, 03600) failed: Invalid
> argument
>
>It sounds like you don't have SysV semaphore support enabled, or perhaps
>just have the limits set too low. See
>http://www.postgresql.org/docs/7.3/static/kernel-resources.html
>particularly the Solaris section.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html