Обсуждение: No postgres on Solaris
Hi, I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and was about to upgrade to 7.1-test, and after following carefully the docs, I get this: postgres@ultra31:~ > /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data IpcSemaphoreCreate: semget(key=5432004, num=17, 03600) failed: No space left on device This error does *not* mean that you have run out of disk space. It occurs either because system limit for the maximum number of semaphore sets (SEMMNI), or the system wide maximum number of semaphores (SEMMNS), would be exceeded. You need to raise the respective kernel parameter. Look into the PostgreSQL documentation for details. postgres@ultra31:~ > I looked at the FAQ_Solaris, but found nothing on this case. I remember making changes to the kernel parameters when I fist installed postgres, but can't remember where I found that info. Any clues? -- System Administration: It's a dirty job, but someone told I had to do it. ----------------------------------------------------------------- Martín Marqués email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------
"Martin A. Marques" <martin@math.unl.edu.ar> writes: > It occurs either because system limit for the maximum number of > semaphore sets (SEMMNI), or the system wide maximum number of > semaphores (SEMMNS), would be exceeded. You need to raise the > respective kernel parameter. Look into the PostgreSQL documentation > for details. [...] > I looked at the FAQ_Solaris, but found nothing on this case. I remember > making changes to the kernel parameters when I fist installed postgres, but > can't remember where I found that info. I don't remember where on the PG site I found this, but this is what I'm using currently: 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 These lines are all at the bottom of /etc/system. Chris -- ----------------------------------------------------- chris@mt.sri.com Chris Jones SRI International, Inc.
Martin A. Marques writes: > IpcSemaphoreCreate: semget(key=5432004, num=17, 03600) failed: No space left > on > device http://www.postgresql.org/devel-corner/docs/postgres/kernel-resources.htm#SYSVIPC -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
El Lun 11 Dic 2000 12:07, Martin A. Marques escribió: > Hi, > I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and > was about to upgrade to 7.1-test, and after following carefully the docs, I > get this: > > postgres@ultra31:~ > /usr/local/pgsql/bin/postmaster -D > /usr/local/pgsql/data IpcSemaphoreCreate: semget(key=5432004, num=17, > 03600) failed: No space left on > device Sorry, checked the FAQ (I thought this would be in the FAQ_Solaris, but it was in the general), and I just recompiled without the --with-maxbackends=64, so I ran out of semaphores. Fixed. ;-) -- System Administration: It's a dirty job, but someone told I had to do it. ----------------------------------------------------------------- Martín Marqués email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------
I found it in the PostgreSQL Administrator manual under "Managing Kernel Resources". Wade Oberpriller > > Hi, > I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and > was about to upgrade to 7.1-test, and after following carefully the docs, I > get this: > > postgres@ultra31:~ > /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data > IpcSemaphoreCreate: semget(key=5432004, num=17, 03600) failed: No space left > on > device > > This error does *not* mean that you have run out of disk space. > > It occurs either because system limit for the maximum number of > semaphore sets (SEMMNI), or the system wide maximum number of > semaphores (SEMMNS), would be exceeded. You need to raise the > respective kernel parameter. Look into the PostgreSQL documentation > for details. > > postgres@ultra31:~ > > > I looked at the FAQ_Solaris, but found nothing on this case. I remember > making changes to the kernel parameters when I fist installed postgres, but > can't remember where I found that info. > > Any clues? > > -- > System Administration: It's a dirty job, > but someone told I had to do it. > ----------------------------------------------------------------- > Martín Marqués email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > ----------------------------------------------------------------- >
Sorry...that url for easy PostgreSQL (windowsm
Sorry for the website is not accessble that time .... but now it can be access at this url http://208.160.255.143 this include an easy installation of PostgreSQL v.7.0.2 for windows 98,2000 and NT. there is a pg guardian that automatically start and setup ur server and many more...:) hope you like this piece of program.... ian