X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D6DD73A568C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  3 Dec 2004 13:37:59 +0000 (GMT)
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 84859-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  3 Dec 2004 13:37:35 +0000 (GMT)
Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50])
	by svr1.postgresql.org (Postfix) with ESMTP id 7CF493A56D0
	for <pgsql-sql@postgresql.org>; Fri,  3 Dec 2004 13:37:36 +0000 (GMT)
Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1])
	by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id iB3E9nmT012302;
	Fri, 3 Dec 2004 16:09:49 +0200
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id
	iB3E9lCh012298; Fri, 3 Dec 2004 16:09:48 +0200
Date: Fri, 3 Dec 2004 16:09:47 +0200 (EET)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Andrew M <andrew@jibeya.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Failed system call was shmget(key=1, size=1155072, 03600).
In-Reply-To: <D5FFC45E-4509-11D9-8632-0003938366A4@jibeya.com>
Message-ID: <Pine.LNX.4.44.0412031608450.12295-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-7
Content-Transfer-Encoding: 8BIT
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200412/29
X-Sequence-Number: 19649

O Andrew M έγραψε στις Dec 3, 2004 :

> Hi,
> when building postgreSQL 8 I get the following error message:
> 
> DETAIL:  Failed system call was shmget(key=1, size=1155072, 03600).
> HINT:  This error usually means that PostgreSQL's request for a shared 
> memory segment exceeded available memory or swap space. To reduce the 
> request size (currently 1155072 bytes), reduce PostgreSQL's 
> shared_buffers parameter (currently 50) and/or its max_connections 
> parameter (currently 10)
> 
> What is the best way to resolve this? max_connections = 10? Does that 
> figure auto increase as more users request data?
> 
> regards
> 
> Andrew

This has been addressed many times, and for many OS's
(*Linux, *BSD, etc...).
Check the archives.

> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

-- 
-Achilleus