Postgres Pro
Downloads
Home   >   mailing lists

Re: LOG: could not fork new process for connection: Cannot allocate memory - Mailing list pgsql-general

From John R Pierce
Subject Re: LOG: could not fork new process for connection: Cannot allocate memory
Date
Msg-id 34d2a3ec-6465-b687-5ba3-a3c167a6434c@hogranch.com
Whole thread Raw
In response to LOG: could not fork new process for connection: Cannot allocate memory  (Ahsan Ali <ali95695@gmail.com>)
Responses Re: LOG: could not fork new process for connection: Cannot allocate memory  (Ahsan Ali <ali95695@gmail.com>)
List pgsql-general
Tree view 
On 8/25/2016 11:49 AM, Ahsan Ali wrote:
>
> I having my production server service intruption because of this
> "Cannot allocate memory" error in the db log.

could you paste the whole error message?

what version of postgres is this?

what OS (if linux, distribution) version is this?


older versions of postgres require kernel.shmmax and some other settings
to be increased if you request larger shared_memory settings.   this is
likely what you're running into.


--
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Understanding Postgres Memory Usage
Next
From: Theron Luhn
Date:
Subject: Re: Understanding Postgres Memory Usage