Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group