Re: Problem in starting postgres server on sun solaris 5.7 - Mailing list pgsql-admin

From Gregory S. Williamson
Subject Re: Problem in starting postgres server on sun solaris 5.7
Date
Msg-id 71E37EF6B7DCC1499CEA0316A256832801D4B9B0@loki.wc.globexplorer.net
Whole thread Raw
In response to Problem in starting postgres server on sun solaris 5.7  (Dattaram Shivji <dshivji@darya.nio.org>)
List pgsql-admin
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
sharedmemory.   
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
postgresdocuments for sysads and look for shared memory settings. By default none of this is enabled, i believe. You
willprobably 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@darya.nio.org]
Sent:    Sat 10/16/2004 1:27 AM
To:    pgsql-admin@postgresql.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@postgresql.org




pgsql-admin by date:

Previous
From: Christian Fowler
Date:
Subject: Re: set AUTOCOMMIT OFF in psqlrc not having affect
Next
From: Gaetano Mendola
Date:
Subject: Single table vacuum full different when vacuum full the whole database