From: Tom Lane <tgl@sss.pgh.pa.us>
To: Don Drake <dondrake@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres stopped running (shmget failed)
Date: Tue, 25 Jan 2005 11:18:05 -0500
Message-ID: <3962.1106669885@sss.pgh.pa.us> (raw)
In-Reply-To: <6c21003b05012507104989efed@mail.gmail.com>
References: <6c21003b05012507104989efed@mail.gmail.com>
Don Drake <dondrake@gmail.com> writes:
> This morning I found the postgres not running and the following in my log file:
> 2005-01-25 01:38:22 FATAL: could not create shared memory segment:
> Cannot allocate memory
> DETAIL: Failed system call was shmget(key=5432001, size=273383424, 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 273383424 bytes), reduce PostgreSQL's
> shared_buffers parameter (currently 32768) and/or its max_connections
> parameter (currently 40).
I have seen this happen when the old shmem segment didn't get released
for some reason, and your kernel settings are such that it won't allow
creation of two shmem segments of that size at once. For robustness
it's probably a good idea to make sure you *can* create two such
segments at once, but for the moment getting rid of the old one with
"ipcrm" should be enough to let you restart the postmaster.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, dondrake@gmail.com
Subject: Re: Postgres stopped running (shmget failed)
In-Reply-To: <3962.1106669885@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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