Обсуждение: shmget fails for min buffers of postmaster also on solaris 7 .....

Dear All,

   I have installed postgres 7.0.2 on solaris 7 on an
intel based machine. But, when I am trying to run the
postmaster( the database startup) with minimum buffers
also it gives the following error

****************
IpcMemoryCreate: shmget failed (Invalid argument)
key=5432001, size=1104896, per
mission=600
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and
platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
FATAL 1:  ShmemCreate: cannot create region
****************

Then I have read the POSTGRES on SOLARIS and other
FAQ's and then edited the /etc/system file and added
the following entries to increase the shared memory
size to 128MB.

********
set shmsys:shminfo_shmmax=268435456
set shmsys:shminfo_shmmin=200
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100
********

Inspite of this I am unable to start the postmaster.
Can anybody Please suggest me a solution for this
problem. It would be of great help if someone can
suggest me what all changes in the OS or postgres are
to be made for starting postmaster with 512 buffers.

Thanks for all suggestions.

Thanks & Regards
Rajesh.

__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/

>
>Then I have read the POSTGRES on SOLARIS and other
>FAQ's and then edited the /etc/system file and added
>the following entries to increase the shared memory
>size to 128MB.
>
>********
>set shmsys:shminfo_shmmax=268435456
>set shmsys:shminfo_shmmin=200
>set shmsys:shminfo_shmmni=200
>set shmsys:shminfo_shmseg=200
>set semsys:seminfo_semmap=250
>set semsys:seminfo_semmni=500
>set semsys:seminfo_semmns=500
>set semsys:seminfo_semmsl=500
>set semsys:seminfo_semmnu=500
>set semsys:seminfo_semume=100
>********
>
>Inspite of this I am unable to start the postmaster.

Well, we had similar problems on Solaris 5.6 some time before.
I think we had to add the following lines to /etc/system to make
it work:

forceload: sys/semsys
forceload: sys/shmsys

So we have the following lines added to /etc/system, although
I am no longer clear about what of these was necessary to start
postgres:

forceload: sys/semsys
forceload: sys/shmsys
set shmsys:shminfo_shmmax=268435456
set shmsys:shminfo_shmseg=20
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100
set semsys:seminfo_semmni=200

Thomas Mack
TU Braunschweig, Abt. Informationssysteme