Shared memory segment error
От | Alexander Cohen |
---|---|
Тема | Shared memory segment error |
Дата | |
Msg-id | 633CF457-A39B-11D8-96CA-000A95B947DC@toomuchspace.com обсуждение исходный текст |
Ответы |
Re: Shared memory segment error
|
Список | pgsql-general |
Hi, sometimes ill get this error: FATAL: could not create shared memory segment: Cannot allocate memory DETAIL: Failed system call was shmget(key=2, size=4153344, 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 4153344 bytes), reduce PostgreSQL's shared_buffers parameter (currently 400) and/or its max_connections parameter (currently 20). The PostgreSQL documentation contains more information about shared memory configuration. I was what exactly this shared memory space is used for and what size is good to set it to. I need to be able to start up many backends (postgres) without using the postmaster. thanks! -- Alexander Cohen http://www.toomuchspace.com (819) 348-9237 (819) 432-3443
В списке pgsql-general по дате отправления: