Re: Problems while starting DB

From: Sathish Somanathan <sathish(at)cisco(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems while starting DB
Date: 2003-10-22 15:35:07
Message-ID: 4.3.2.7.2.20031022083300.03f99210@mira-sjcd-2.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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(at)cisco(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff 2003-10-22 15:46:34 Re: Need PGSQL ODBC Driver for Solaris
Previous Message scott.marlowe 2003-10-22 15:11:41 Re: File system level backup