shared memory after server kill
| От | Sean Davis | 
|---|---|
| Тема | shared memory after server kill | 
| Дата | |
| Msg-id | 1673B893-E6CB-11D8-8272-000A95D7BA10@mail.nih.gov обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: shared memory after server kill
            		
            		 Re: shared memory after server kill  | 
		
| Список | 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 по дате отправления: