pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFailed system call was shmget(key=1, size=1155072, 03600).
3+ messages / 3 participants
[nested] [flat]
* Failed system call was shmget(key=1, size=1155072, 03600).
@ 2004-12-03 09:00 Andrew M <andrew@jibeya.com>
0 siblings, 2 replies; 3+ messages in thread
From: Andrew M @ 2004-12-03 09:00 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Failed system call was shmget(key=1, size=1155072, 03600).
@ 2004-12-03 14:09 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: Andrew M <andrew@jibeya.com>
1 sibling, 0 replies; 3+ messages in thread
From: Achilleus Mantzios @ 2004-12-03 14:09 UTC (permalink / raw)
To: Andrew M <andrew@jibeya.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Failed system call was shmget(key=1, size=1155072, 03600).
@ 2004-12-03 17:19 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Andrew M <andrew@jibeya.com>
1 sibling, 0 replies; 3+ messages in thread
From: Andrew Sullivan @ 2004-12-03 17:19 UTC (permalink / raw)
To: pgsql-sql
On Fri, Dec 03, 2004 at 09:00:53AM +0000, Andrew M wrote:
> 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?
What are you trying to run this on? It might be that you need to
alter your kernel settings.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism.
--Brad Holland
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-12-03 17:19 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-03 09:00 Failed system call was shmget(key=1, size=1155072, 03600). Andrew M <andrew@jibeya.com>
2004-12-03 14:09 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2004-12-03 17:19 ` Andrew Sullivan <ajs@crankycanuck.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox