Re: Problem in starting postgres server on sun solaris 5.7

As root you will need to edit the /etc/system file to add some information for the OS about how much RAM to use for shared memory.
These are settings for Informix (don't have a postgres SUN setup at hand and don't have doucumentation either):

set shmsys:shminfo_shmmax=1205306368
set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=4352
set semsys:seminfo_semmns=4352
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=64
set semsys:seminfo_semmsl=100
set shmsys:shminfo_shmmin=100
set shmsys:shminfo_shmmni=356
set shmsys:shminfo_shmseg=4352

Postgres does not require all of these and uses shared memory in a somewhat different way so you should check the postgres documents for sysads and look for shared memory settings. By default none of this is enabled, i believe. You will probably need to reboot the server when you have edited the system file and then restart postgres.

HTH,

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: Dattaram Shivji [mailto:dshivji(at)darya(dot)nio(dot)org]
Sent: Sat 10/16/2004 1:27 AM
To: pgsql-admin(at)postgresql(dot)org
Cc:
Subject: [ADMIN] Problem in starting postgres server on sun solaris 5.7

Hi!

I installed postgresql-7.2.1 on Sun solaris 5.7 running on sparc processor.

while installing i had no problems but as soon as start with following
line

/usr/local/pgsql/bin/postmaster -D /user2/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /user2/pgsql/data -l logfile start

kailas# /usr/local/pgsql/bin/postmaster -D /user2/pgsql/data
IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed:
Invalid argument

This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter. You can either
reduce the request size or reconfigure the kernel with larger SHMMAX.
To reduce the request size (currently 1441792 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).

If the request size is already small, it's possible that it is less than
your kernel's SHMMIN parameter, in which case raising the request size or
reconfiguring SHMMIN is called for.

The PostgreSQL Administrator's Guide contains more information about

shared memory configuration.

I am a new person with sun solaris so please sugest me in details i you
can !

with regards

Dattaram

(Sys Admin)
POD div.
National Institute of Oceanography

Donapaula -Goa
India

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org