Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory
Дата
Msg-id 517778FC.8090804@hogranch.com
обсуждение исходный текст
Ответ на Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory  (Khangelani Gama <kgama@argility.com>)
Ответы Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory
Список pgsql-general
On 4/23/2013 11:08 PM, Khangelani Gama wrote:
> Hi  John
>
> Yes that's the whole messege
>


well, try something like...

     kernel.shmmax = 4294967295
     kernel.shmall = 268435456

at the end of /etc/sysctl.conf, then execute `sysctl -p` and try to
start postgres again.

(it really doesn't matter if you set those kernel limits too large, they
have no negative impact, they are simply quota, the max allowed.   The
only reason to restrict them is on a shared system with
hostile/malicious users like students who might mess with grabbing
excessive memory and causing a denial of service. )




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



В списке pgsql-general по дате отправления:

Предыдущее
От: Khangelani Gama
Дата:
Сообщение: Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory
Следующее
От: Khangelani Gama
Дата:
Сообщение: Re: FATAL: shmat(id=3342337) failed: Cannot allocate memory