X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BD4B5D1EBFE for ; Tue, 23 Mar 2004 17:55:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96318-07 for ; Tue, 23 Mar 2004 13:55:09 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 0F93BD1E9C2 for ; Tue, 23 Mar 2004 13:55:09 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i2NHt81Y059501 for ; Tue, 23 Mar 2004 17:55:08 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i2NHhqQF054583 for pgsql-sql@postgresql.org; Tue, 23 Mar 2004 17:43:52 GMT From: xvx X-Newsgroups: comp.databases.postgresql.sql Subject: Re: could not create shared memory segment: Invalid argument Date: Tue, 23 Mar 2004 12:30:36 -0600 Message-ID: Organization: Web Servers forum User-Agent: www.webservertalk.com news gateway X-Newsreader: www.webservertalk.com news gateway X-Originating-IP: 24.228.1.176 References: Lines: 43 X-Complaints-To: abuse@giganews.com X-DMCA-Notifications: http://www.giganews.com/info/dmca.html X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/248 X-Sequence-Number: 17347 I'am also getting this same problem with 10.3.3 Server. Worked fine with 10.3.2. kern.sysv.shmmax: 4194304 kern.sysv.shmmin: 1 kern.sysv.shmmni: 32 kern.sysv.shmseg: 8 kern.sysv.shmall: 1024 Those are the Values i get from the command posted. Have you figured out a fix for this error? Thanks. beyaNet Consultancy wrote: > *Hi, > I have just installed the latest version of OS X panther (10.3.3) > and > am now getting the following error message: > > postgres$ /usr/local/pgsql/bin/postmaster -i -D > /usr/local/pgsql/data > FATAL: could not create shared memory segment: Invalid argument > DETAIL: Failed system call was shmget(key=5432001, size=10444800, > 03600). > HINT: 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 10444800 bytes), reduce > PostgreSQL's shared_buffers parameter (currently 1000) and/or its > max_connections parameter (currently 100). > 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 documentation contains more information about > shared memory configuration. > > Any ideas on how i can resolve this issue? > > many thanks in advance > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster * -- xvx ------------------------------------------------------------------------ Posted via http://www.webservertalk.com ------------------------------------------------------------------------ View this thread: http://www.webservertalk.com/message151918.html