shared memory after server kill

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: pgsql-novice(at)postgresql(dot)org
Subject: shared memory after server kill
Date: 2004-08-05 10:34:53
Message-ID: 1673B893-E6CB-11D8-8272-000A95D7BA10@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a problem that I can't understand.

I am using macosx, pg 7.4.3. I had a server running and working. I
tried to bring the server down with 'pg_ctl stop', which failed (server
running on localhost). I then (timidly) killed the postmaster process.

When I tried to bring the server back up, I got an error similar to:

FATAL: could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=1, size=1081344, 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 1081344 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 50) and/or its max_connections
parameter (currently 10).
The PostgreSQL documentation contains more information about
shared memory configuration.

I have 4 Gb of memory, with approximately 2.6 Gb available (via top)
and a vast swap. What is going on?

Thanks,
Sean

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2004-08-05 10:47:17 Re: shared memory after server kill
Previous Message Oliver Fromme 2004-08-05 08:53:36 Re: Column name truncation