shared memory after server kill - Mailing list pgsql-novice

From Sean Davis
Subject shared memory after server kill
Date
Msg-id 1673B893-E6CB-11D8-8272-000A95D7BA10@mail.nih.gov
Whole thread Raw
Responses Re: shared memory after server kill
Re: shared memory after server kill
List 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


pgsql-novice by date:

Previous
From: Oliver Fromme
Date:
Subject: Re: Column name truncation
Next
From: Sean Davis
Date:
Subject: Re: shared memory after server kill