Failed system call was shmget(key=1, size=1155072, 03600).

From: Andrew M <andrew(at)jibeya(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Failed system call was shmget(key=1, size=1155072, 03600).
Date: 2004-12-03 09:00:53
Message-ID: D5FFC45E-4509-11D9-8632-0003938366A4@jibeya.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2004-12-03 14:09:47 Re: Failed system call was shmget(key=1, size=1155072, 03600).
Previous Message Andrew - Supernews 2004-12-02 10:07:52 Re: find the "missing" rows