X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BF17432A13A for ; Sat, 16 Oct 2004 09:32:28 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10411-05 for ; Sat, 16 Oct 2004 08:32:25 +0000 (GMT) Received: from gw1.nio.org (fw1.nio.org [210.212.160.229]) by svr1.postgresql.org (Postfix) with ESMTP id A5F6732A0D8 for ; Sat, 16 Oct 2004 09:32:24 +0100 (BST) Received: from darya.nio.org (localhost.localdomain [127.0.0.1]) by gw1.nio.org (8.11.2/8.11.2) with ESMTP id i9G8RvV11556 for ; Sat, 16 Oct 2004 13:57:57 +0530 Received: from 192.168.1.1 (192.168.1.1) by ASSP-nospam ; 16 Oct 04 08:27:57 -0000 Received: from darya.nio.org (localhost [127.0.0.1]) by darya.nio.org (8.11.2/8.11.2) with ESMTP id i9G8W5829272 for ; Sat, 16 Oct 2004 14:02:06 +0530 Message-ID: <4170DB83.7050007@darya.nio.org> Date: Sat, 16 Oct 2004 13:57:47 +0530 From: Dattaram Shivji User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-GB; rv:1.6) Gecko/20040115 X-Accept-Language: en-gb, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Problem in starting postgres server on sun solaris 5.7 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Spam-Prob: 0.00000 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/202 X-Sequence-Number: 15195 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