Failed system call was shmget(key=1, size=1155072, 03600). - Mailing list pgsql-sql

From Andrew M
Subject Failed system call was shmget(key=1, size=1155072, 03600).
Date
Msg-id D5FFC45E-4509-11D9-8632-0003938366A4@jibeya.com
Whole thread Raw
Responses Re: Failed system call was shmget(key=1, size=1155072, 03600).
Re: Failed system call was shmget(key=1, size=1155072, 03600).
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Andrew - Supernews
Date:
Subject: Re: find the "missing" rows
Next
From: Achilleus Mantzios
Date:
Subject: Re: Failed system call was shmget(key=1, size=1155072, 03600).