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:[EMAIL PROTECTED] Sent: Sat 10/16/2004 1:27 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
